Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combo displaying info from multiple tables

Status
Not open for further replies.

Russie

Programmer
Dec 24, 2000
104
US
Hi.

Is it possible for a combo box to display columns from more than one table?

Thanks.
 
How are ya Russie . . . . .

Yes! . . . . to a point [blue]depending if the tables are related or not.[/blue]

Basically, you make a query to give you what you want and set the [blue]RowSource[/blue] of the Combobox to the [blue]Name of the query.[/blue]

If the tables are not related, [purple]you'll have to play with joins to see if you can get it right.[/purple] [blue]This could be prohibitive![/blue]

[blue]GoodLuck![/blue]

Calvin.gif
See Ya! . . . . . .
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top