View query results in a form

[lexis7]

I have two forms, one of them being the "search" form, the other being the "View" form.

The search form has text boxes that are used as criteria for a query. The query pulls all fields of the table and views the results in datasheet view. That works wonderfully.

Now what I want to happen is to have the results of the query to be displayed in the "View" form. the "view" form has all the table fields set up in a nice viewable manner with labels and textboxes, and it allows the users to use the record selectors on the bottom of the form to navigate amoung all the query results.

Is this possible?
I'm so frustrated.

thanks for any help!

 

[RottPaws]

All you have to do is open the view form with the command
DoCmd.OpenForm "ViewFormName"

And then set it's recordsource to the query
Forms!ViewFormName.RecordSource = "Query SQL"

There's more detail on how I create Access search tools at thread181-262790 _________
Rott Paws

...It's not a bug. It's an undocumented feature!!!