Searches that return a form

[me3]

Hi,
I have made a query to search for some items on a table. I want there to be a button on the search form that says 'search' and takes you to the corresponding page on the form. (The form has multiple pages in, all with different products on) Is this possible?

 

[JHB]

... 'search' and takes you to the corresponding page on the form. (The form has multiple pages in, all with different products on)...

What do you mean by "corresponding page"?

 

[me3]

So I have a range of trailers. Each range has various models (different sizes etc) These are all in one form for each range. I then have a page to search for a model in the range. I would like to hit search and the model that would fit the search is displayed.

hope this makes sense

 

[jdraw]

Perhaps you could show a jpg of your tables and relationships to help readers understand your database.

 

[spikepl]

What do you mean by "page"? A form can be subdivided into one or more pages, but since a form has a maximum length this sets a limit to the amount of infomation displayable. Is this your "page"? Show a screen shot of 2 different pages.