Query results inside a form

[twildt]

I have a query built. I dragged it onto my form. At the top of the form I have a text box. I want to be able to enter data into that text box and when I hit enter or tab it runs the query I dragged on the form using the data entered into the text box.

How can this be achieved?

Thanks,
Tom

[June7]

One method is with parameterized query as the form RecordSource. Review: http://www.datapigtechnologies.com/f...tomfilter.html

[NTC]

When you drag a query onto a form; it creates a sub form in datasheet view. So that's really where you are - if I interpret your post correctly. The content of the sub form depends on the master/child link to the main form.....and then is controlled by the record that the main form is on.

[June7]

If this is main/subform arrangement, is the main form bound? If not, could have a solo form in Continuous view, put the filter input text or combo box in the header of the form. The controls in detail section can be arranged to look like datasheet view.

[twildt]

This is a Main form bound to a table. I simply need to read the first text box and make that the entry to the query, run the query, and show the query right on the main form. If it's easier to make the query pop-up instead of being on the main form I am not against that either. I just need the users to be able to view the query easily while still interacting with the main form.

[twildt]

I made some progress and I think I am close.

Main form has a control button on it to requery the subform.

Private Sub AccountSearch_Click()
Me.LookupTest_subform2.Requery
End Sub

Then, the criteria of my Query is pointed to the [Forms]![MainForm]![textbox]

When I click the button it puts the data entered into the textbox on main form, and enters that information into the subform query but it doesn't appear to actually be running the query, meaning it just sticks the data from textbox in first field of subform(datasheet view) and doesn't perform the query, no other information is displayed.

I feel I am close, what do you think?

[twildt]

Figured it out. Instead of running the query from control button I am simply performing a requery on the subform, which is bound to the mainform first textbox. Working great!