Search query relating to a combobox

[goldenvision]

I have a form based on a table which contains name and address information. Each record in the table is issued with a KeyID. Each record in the table can have upto 7 claim references against it. I have created a one to many join between the name and address table and the claim reference table.

I have a combo box on the form to search via name and address. I also want another combo box on the form to search via claim reference number which is held on another table.

How do I go about it

 

[PegasusBR]

It is hard to respond because there are several ways you might have set up your initial combo box to work. I assumed you used the Combo Box Wizard as a starting place.

I've attached a file with my solution. Basically, I would set up a combo box (and related code) that is almost identical to the first except that the Row Source of the new combo box would be based off the table that contains your claims and include the two fields KeyID and ClaimRefNum.

Hope this helps.

 

[goldenvision]

Thanks matey

I posted the same question on UtterAccess.com and the reply that came back was pretty much the same as yours and it worked a treat.

thanks for the help