VBA to display synchcronised data [URGENT]

[websterh]

Hey, I know this sounds basic but it was working previously and now it's not. + it's Urgent (for work)



2 combo boxes:
First == looks up a facility list (named Facility - from CLIENT table)
Second == looks up MRN, surname and first name ( - from CLIENT table)
(( MRN = number .... Facility, surname, first name = text ))
'afterupdate' for both of these (esp First) is fine for me/got that understood.

now i can get the second combo to display the choice of first combo (i.e. HosA only records shown) but when i want it to display it in the CLIENT form it either: doesn't show up now, or shows the first MRN (same MRN at two locations, location A-Z order). i had it working before but now it isn't. i have also copied the relevant areas to a clean database and it's worse than before (not displaying the First/Second selection on CLIENT form).

i have tried in 2003 and 2007 (for VBA and macro auto builds) but cannot update the criteria to match both combo boxes for display.
.... the 'findfirst' has MRN but not sure how to make the facility choice selected too.

any help greatly appreciated.
thanks.

[orange]

There is a free video tutorial here that deals with 2 related cascading combo boxes.
http://www.datapigtechnologies.com/f...combobox2.html