Populate my form with parameter query results

[Tom K via AccessMonster.com]

Hi
Im using a command button on my form to open a parameter query. The query
runs and asks for input and then shows the query results. How can I populate
my form with these results? I dont need to see the query, I just want the
fields on the form to reflect the query results.

Thanks
'
Tom

 

[fredg]

Hi
Im using a command button on my form to open a parameter query. The query
runs and asks for input and then shows the query results. How can I populate
my form with these results? I dont need to see the query, I just want the
fields on the form to reflect the query results.

Thanks
'
Tom

Create a form using the query as it's record source.
Open the form from the command button (not the query).
Enter the parameters when prompted.