Autogenerating Forms from Query Results

[samhill]

Hi Guys,

I've been charged with creating a database for a bunch of radio licences that include many fields of data. I have set up the database and written a query linkey to a search form that allows users to search for the ID number of the Licence, aswell as the name and location.
However, once the query is run the data comes out as would expect (excel style form) in cells and colums. What I want is to generate a form for each of the search results automatically everytime a query is run.

How can I do this?

 

[Geotch]

You can create a form from the query( your search results). Your query will be the record source of the form.

Instead I opening the query when you search, open the form instead. You can do all this with a Macro. Hope that helps.