combox find record field

[miziri]

Hi,
I have two form,master and child
i need to make combox field find record in master while original record search will in child form .
example
I have in master form company name and items and qty. child phone and address
both are form are connect via key i mean master and child appear in one form.


I want to put combox filed for find record on master form ,but my search will by in filed of child like phone number
i must show up company items and qty.

Thanks

[ranman256]

for the master form combo
combo after_update() event

me.filter = "[CoName]=' " & cboCo & "'"
me.filteron = true

for the combo to find phone in child, but not knowing the master name

vName = Dlookup("[coName]","query","[phone]='" & txtPhone & "'"
 
if not Isnull(vName ) then 
   cboCo = vName
   combo after_update() event
endif

[miziri]

Hi
See attached and I think I was not very clear to u,
may this photo is more clear,if need i attached my database

Thanks