Requery

[Erictsang]

Dear all



I have made a form that will let user to complete the data /requirement for the search

after user input the payment mode, then click search


However, the query need to be manually refresh .. how can i do it that it will automatically refresh as i click the search ?



See below photo

[Bob Fitz]

I would use a form or a report (based on the query) to present the result to the user.

[alansidman]

In the afterupdate event for the text box

me.requery

[orange]

What is the code behind the Search button?

You might consider (untested)
-in the before Update event of the Form
---ensure there is a valid Date
---ensure there is a selection in the combo
---if either is false, then give a message and go back to the control involved.

---if both are true, then do a me.Requery

User then click the button

OR

Do as Alan says if you are not checking for specific values.

[Erictsang]

Orange

I tried but it prompt- i assign this marco in the unbound box

[orange]

Sorry, I don't use macros. I was responding using vba.

[Erictsang]

Bob

Would you be so kind to have a look on my accdb file

Thanks