Help on COMBO BOX

[claudz_08]

I have table x and y. Both table x and y consists of email addresses,first name and last name.
I made an unmatched query from these two tables and i called it table z. In order to get the company names from the results, i made an sql that will extract the company names from the email addresses. So now the datasheet view of table z consists of email addresses,first name, last name and company.

Now I have another table named table R, this table consist of company names only.

Now what i want to do is, i'm gonna have a combo box. In the list of combo box, i want the company names to appear from table R. And when i choose one company,example: blue corporation, i want all the blue corparation from table z to appear. How do i do this? please help.asap.

 

[Oldsoftboss]

If you have foreign keys set, then you should be able to create relationships and use a query to bring it all together.

 

[bradcccs]

Claudz

I thought I knew my alphabet but . . .


IF I understood you correctly, you should base the recordsource of you combo on Table R

Then construct a subform that uses a query based on Table Z.

In the criteria line for Company on the said query, use a reference to the newly created combo

eg: =Forms!FormName.ComboBasedOnTableRName

You will need to requery the subform after updating the combo

If I have missed the target, then I apologise

This reply was brought to you by the letters R, X, Y, Z, and the number 13

Brad.