Diplaying query results in a form

[StlJ]

I have all the back end of my DB done and is all relational and using good standards and now I am trying to make it pretty for the user. I created forms for my queries to search using various field and they all work fine if you just open the form and type in the criteria, it displays on a form as it should.

My problem is that I have a main form where people choose what field they want to search by (tried both cmd button and combo box). The form to ask the search criteria comes up fine and it runs the query and displays the correct results except that now it just shows the "raw" query results in spreadsheet format. This isn't practical because I display about 20 fields, some with a lot of text and they have to scroll through horizontally.

So I need suggestions on how to give the user an option on a "main" form to choose what they want to search by and then display the results in the forms I created based on queries. ANy suggestions welcome. Thanks in advance.

 

[Wiz47]

I have all the back end of my DB done and is all relational and using good standards and now I am trying to make it pretty for the user. I created forms for my queries to search using various field and they all work fine if you just open the form and type in the criteria, it displays on a form as it should.

My problem is that I have a main form where people choose what field they want to search by (tried both cmd button and combo box). The form to ask the search criteria comes up fine and it runs the query and displays the correct results except that now it just shows the "raw" query results in spreadsheet format. This isn't practical because I display about 20 fields, some with a lot of text and they have to scroll through horizontally.

So I need suggestions on how to give the user an option on a "main" form to choose what they want to search by and then display the results in the forms I created based on queries. ANy suggestions welcome. Thanks in advance.

If the fields are basically the same for all the searches, then use a combo that opens a separate form and uses the combo selected query as the record source. I use this method to create different reports for various querys that use the same report template.

If you have different forms for different fields, then have it open both the form and set the record source for it.