Button OnClick to trigger Query results

[rhubarb]

Hello,

I think this question goes here but may be wrong. I have a form with an edit box for user entered data. I want the user to enter a couple of numbers or letters and hit the "find" button. Once the find button is triggered, the data the user entered will be matched against possible matches in a table. I have a query linked to the form and the text box that does this already. I've created a simple macro to 'OpenQuery' that query but it doesn't seem to run successfully. I hit run and "Enter Parameter Value" pops up and I enter a couple of numbers that would match a result in my table but nothing happens.

Any insight is appreciated.

Thank you!

[burrina]

What data type is the edit box, a combobox or just a plain textbox? Here is an example of a ComboBox Lookup. This example finds a Job Number in tblJobs

Set rs = Me.Recordset.Clone
rs.FindFirst "[jobid] = " & Str(Nz(Me![cbojob], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Me.cbojob = Null

HTH

[rhubarb]

Just a plain text box.

[burrina]

Can you post a Demo copy with all confidential data removed for evaluation?

[rhubarb]

Attached. Let me know if I can make more sense of it.


Database1.accdb

[burrina]

There is NO frmCustomer in this db?

[rhubarb]

The Job Address form is the frmCustomer

[rhubarb]

I did forget to add the Macro 'cmd_Find' for the OnClick for the Find button. It just uses the OpenQuery, Datasheet View, and Read Only for data.

[burrina]

There are plenty of ways to do this. Here is your db modified.


HTH

[rhubarb]

Just curious, why did you choose a combo box for the entry? Also, when I migrate the code over the combo box drops the addresses properly but when I click on the button it does not open the query. Thanks for the help on this.