Combo box that updates a sub form

[lck092580]

Hi,

I'd like to do the following:

Created a combo box with text values.

Created a subform at the bottom.

Basically what I'm trying to do now is to just execute a query in the subform depending on what is selected in the combo box.

So lets say the user selects "firstname" in the combo box, the bottom should execute the query:

select contacts."firstname"
from contacts

Then display the details. My query is a bit more complex than the above but is similar. How do I link the subform at the bottom to the combo box above if they're not linked via PK or FK? I just want to grab the string value in the combo box and insert it into my query.

Thanks.

 

[dhookom]

Answered in your other thread with the exact same question. Please limit your questions to a single thread if the question is the same.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]