Using a form as a parameter query

[b9791]

I am trying to use a form that displays two options to search for information and then display the results in a table format directly beneath. Any help would be excellent.

Thanks.

Brian

 

[aqif]

Use List Box

Hi

One better way of doing will be using List Box or even Subform to display the data. The data or rwo source or list box or subfrom should contain query like

Select Field1,Field2 from MyTable Where Field1=Forms!MainForm!SearchBox

Place a Search button next to your search box n just write

DoCmd.Requery "MyListBox"

or if you are using Subform then

DoCmd.Requery "MySubForm"

Cheers!
Aqif