Records from multiple tables in List Box

[Tommy408]

Is it possible to display records from multiple tables in one List Box? The tables have the same field but different values and different ID.

 

[TheAceMan1]

How are ya Tommy408 . . .

Have a look at [blue]Union[/blue] queries!

See Ya! . . . . . .

 

[Tommy408]

This would have to be set through VBA? Anyone know how I can set it without VBA? I've tried messing around with Query Builder, but got no good result.

 

[Tommy408]

All the Join properties in Query Builder are either one or the other not both.

 

[TheAceMan1]

Tommy408 . . .

Your prior two posts show you have'nt looked up [blue]Union Query[/blue] in access help! . . . Make it so! ;-)

See Ya! . . . . . .

 

[Tommy408]

Anyone?
I have a lot of fields and more fields will be added. It'd be nice to know how to pull records from both table from Query Builder view not SQL view.

 

[Tommy408]

Ok, I guess I have to use SQL View to use Union Query.

Thank you.

 

[TheAceMan1]

Tommy408 . . .

All you have to do is make a query (in design view) for each table. When your satisified with results, copy the SQL in SQL view and paste into the SQL View of the Union Query. Just remember to add the Keyword Union to all but the first SQL you paste and that each SQL needs to have proper field alignment,type.

[blue]Select txtField, numField, curField
From table1
Union Select txtField, numField, curField
From table2
Union Select txtField, numField, curField
From table3;[/blue]

See Ya! . . . . . .

 

[Tommy408]

Got it. Thank you for your help.