Combo Box...look up record not available when tables joined?

[Randix]

I've a form that has two tables joined. When I go to add a combo box, i see that the third option to look up a record based on the selection is not available. Why do I feel I missing somethin'...? How can i use a combo box in this situation to bring up a record?

 

[charityg]

In order to have this option available, you must save the sql statement that the form is based on as an actual query. Just go into the query builder like you are are going to change the query and click the save icon. Type in a name to save the qry as. I usually use qryFormname where Formname is the name of the form the query is used.

HTH
Charity

 

[Randix]

Thanks! As usual, about the same time you posted, I finally figured it out...must be therapeutic posting here

Thanks again for your assistance! Love this place.