Oct 20, 2004 #1 Russie Programmer Dec 24, 2000 104 US Hi. Is it possible for a combo box to display columns from more than one table? Thanks.
Oct 20, 2004 #3 TheAceMan1 Programmer Sep 23, 2003 11,174 US 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] See Ya! . . . . . . Upvote 0 Downvote
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] See Ya! . . . . . .