There are multiple records that can be returned. Here is an example.

Type Name Location New
A camera 1st floor 1
B camera 2nd floor 0
A camera 3rd floor 1

My input is to query on the Type and return all records with that type:
Input = 'A' should return on the Form:
Type Location New
A 1st floor 1
A 3rd floor 1

I have hundreds of types, therefore a Combo box would not work.



"anthony" wrote:

On Apr 19, 7:07 pm, Mommybear
wrote:
I have created a form that is populated from a query. I have a text box set
up as an input box and click a button (Search) to execute the search. This
appears to be working fine as the query opens and runs. However, it displays
in the query in data format instead of in the Form I created. How do I get
this information to populate the form, not the actual query. The Search
button is set to RunQuery.

If I understand you correctly, you have based the form on the query ie
the form displays the data returned by the query. If so, use a combo
box on the form (when you drop the combo control on the form, the
wizard will guide you). This will take you to the record you want
.