Search -> Select -> Display

[markcrobinson]

I have a form with Customer information and a subform with all their invoices.
I put a search text box on top of the form and a search Button
The search button executes a query
Like "*" & [Forms]![CustomerDisplay]![Search] & "*"
That displays all the records the user might be looking for.
I want the user to select the correct name, have that name fill the top of the form so the subform will display his invoices.

How does the user "select" the correct name for the list?
How do I get this info back into the form?

Thank you!

[Gicu]

Many ways to do that... Use the query to populate a list box, combobox or subform placed in the header of your mani form, then use the AfterUpdate event of whatever control you decide to go with to requery the main form (which has a recordsource refering to that combo , listbox or subform - Select Customer.* FROM Customer Where CustomerID= FOrms!frmMainForm.lstListboxFiltered).

Cheers,
Vlad

[markcrobinson]

Thank you.
Use the query to populate a list box
So my button calls the query with the "like" criteria and the query shows up. I click on the record I want -- then how do I refer to that record? I think you're suggesting a Recordsource referring...
What would be an excample of a recordsource referring to that query current record?

I do understand how to use a combox box for a search, but the combo box does not easily accommodate a "like" search. Currently, I put the "Like" criteria is [CustomerDisplay]![Search], then have to run the combox box -- maybe that's the best way...

[markcrobinson]

Nevermind (in the voice of Emily Natella)
Got it.

I have a form with Customer information and a subform with all their invoices.
I put a search text box on top of the form and a search Button
The search button executes a query
Like "*" & [Forms]![CustomerDisplay]![Search] & "*"
That displays all the records the user might be looking for.
I want the user to select the correct name, have that name fill the top of the form so the subform will display his invoices.

How does the user "select" the correct name for the list?
How do I get this info back into the form?

Thank you!

[Gicu]

Glad to hear you got it working, the "like" query is the row source of the listbox then the main form is filtered by the selection in the listbox.

Cheers,
Vlad

[ssanfu]

The search button executes a query
Like "*" & [Forms]![CustomerDisplay]![Search] & "*"

Be aware that "Search" is a reserved word in Access and shouldn't be used for object names.
Since you are referencing a text box control, maybe change the name of the control to "tbSearch" (tb - text box) or "txtSearch".