Populate text boxes from union query?

[Guest]

I have a union query that searches 3 tables for a store number, scope of work
and completion date. I want to take the results of this query for each store
and display them in text boxes on a History tab in the main form.

SELECT [StoreNumber], [TargetCompletion], [ScopeofWork]
FROM [RemodelInfo]
WHERE [TargetCompletion] is not Null

Given that different stores will have different numbers of records for each
one (i.e. we remodeled store #1 twice, but #95 has been done 5 times) how do
I reference the query as the data source for the fields?

 

[Guest]

Create a subform that uses your query as it's record source.

 

[Guest]

Klatuu, did I loose you from my list box ? if so pls let me know. thanks, rob

Create a subform that uses your query as it's record source.
--
Dave Hargis, Microsoft Access MVP

I have a union query that searches 3 tables for a store number, scope of work
and completion date. I want to take the results of this query for each store
and display them in text boxes on a History tab in the main form.

SELECT [StoreNumber], [TargetCompletion], [ScopeofWork]
FROM [RemodelInfo]
WHERE [TargetCompletion] is not Null

Given that different stores will have different numbers of records for each
one (i.e. we remodeled store #1 twice, but #95 has been done 5 times) how do
I reference the query as the data source for the fields?