Requery Problem

[Erictsang]

Dear all is me again, for the Requery



I tried and set the following in the unbound box

Private Sub Pay_search_AfterUpdate()


Me.Pay_search.Requery
End Sub

Still it does not work ...i have to close the Query and let it reopens to get the new result.

https://www.dropbox.com/s/b18dexj22q...ery.accdb?dl=0

Appreciate any help.

Eric

[June7]

Duplicate thread https://www.accessforums.net/showthread.php?t=67819

If you want to refresh a query or report object, why are you requerying combobox?

[Erictsang]

Then, how I can get the result?
,user can re enter the request and the query can be updated without closing it
Eric

[John_G]

I tried and set the following in the unbound box

This statement: Me.Pay_search.Requery is requerying the combo box, and nothing else. You are using the combo box to select a name - but why do you requery it - there seems to be no point.

After a name is selected from the combo box, what exactly to you want to happen? What query are you talking about when you say "...i have to close the Query and let it reopens to get the new result."

If I understand you correctly, you have a SELECT query open, and you want to change the results in that query when you make a change in the combo box selection.

So that we can better see what is happening, please post the SQL of the query you have open, and want to refresh.

[Erictsang]

John

I want to requery the Query.

After the user reinput the combox

How can i do it ?

Eric

[davegri]

So if the query has to close and reopen, code the button like this:

Attachment 30214

[John_G]

There is no method to requery a query. You have to close and rerun it; in fact that is what Access does anyway when you use the requery method.

I'll ask you again - please post the SQL of the query. I want to know what you are changing that requires the query be reun, e.g. are you referencing a form field in the query's criteria clause.

[Erictsang]

John

Frankly, it a new baby for Access

SELECT Master_Data.ID, Master_Data.Title, Master_Data.Fname, Master_Data.Hotel, Master_Data.Reg_Fee, Master_Data.Reg_Paymode, Master_Data.ACC_TTL, Master_Data.ACC_Paymode
FROM Master_Data
WHERE (((Master_Data.Reg_Paymode)=[Forms]![Pay_search]![Pay_search])) OR (((Master_Data.ACC_Paymode)=[Forms]![Pay_search]![Pay_search]));

[June7]

The only way I can see to refresh an open query is for the query to have focus and then click the RefreshAll button on the ribbon.

Finally answers my question posed in other thread about whether the query has dynamic parameters.

Again, why do you even need to have query open? Just open form or report using query as RecordSource. Methods to requery an open report have already been provided in your other thread.