sql - Creating a search query in Microsoft Access to query unbound fields and subform -

sql - Creating a search query in Microsoft Access to query unbound fields and subform -

i cannot seem figure out. have made far database @ loss. going post screenshots , details below , hope plenty info.

this main form (dashboard). shows status of calls employee has received. need implement search. search client or part.

my goal have come in string in search field , retrieve matches display on details (that contains subfrom)

this detail screen. shows client , part(s) on subform. client info unbound due way handled. have client master table employee can search , add together call. if client not in master table can come in 1 manually. unbound boxes tied customerid field.

these relationships database

this function matches customerid fill unbound boxes

this table detail form

and table subform

sql database ms-access access-vba