How to requery from a form button (1 Viewer)

sumdumgai · Oct 16, 2018

Hi again. I'm new to forms design. I've created a Form that accepts multiple field inputs and the Query that uses those inputs to select records into a datasheet view. When I change the parameters on the Form, the query does not update the resulting datasheet. I have to close the query result and then the Form button produces the new result. Is there a way besides using VBA that I can re-query the database using the new parameters?
Thanks.

June7 · Oct 16, 2018

Is the query the RecordSource of form?

Try:

Me.Requery

sumdumgai · Oct 16, 2018

Thanks for reply. The query is a select query that I created using Query Design. On the Form, I have a button that runs that query. The recordSource is a table and the form is unbound. Does that make sense? Like I said, I'm pretty knew to forms.

June7 · Oct 16, 2018

Don't open query. Open form or report bound to query.

The_Doc_Man · Oct 16, 2018

Something about your setup sounds odd. June7 is right that normally you would bind the form to an underlying record, in which case Access would take care of business for you.

So ... what's up with this form design that you DIDN'T want it bound to the record? I am not clear on your intent here.

arnelgp · Oct 16, 2018

if the query is already open, close it again and then re-open:

private sub button_click()
If syscmd(acSysCmdGetObjectState, acQuery, "theNameOfQuery") <> 0 Then _
DoCmd.Close acQuery, "theNameOfQuery"
DoCmd.OpenQuery "theNameOfQuery"
end sub

June7 · Oct 16, 2018

If you really must refresh a query that is open, and don't want to close:

CommandBars.ExecuteMso "DataRefreshAll"

arnelgp · Oct 16, 2018

that will only work if the Query has the focus.

private sub button_click()
If syscmd(acSysCmdGetObjectState, acQuery, "theNameOfQuery") <> 0 Then
DoCmd.SelectObject acQuery, "theNameOfQuery", False
commandbars.ExecuteMso("DataRefreshAll")

Else
DoCmd.OpenQuery "theNameOfQuery"
End If
end sub

June7 · Oct 16, 2018

Thanks, I have never actually used that code. Just picked up from somewhere in another similar thread. So always forget about the focus issue.

sumdumgai · Oct 16, 2018

Thanks to everyone. I found another solution in another thread that I posted.

How to requery from a form button (1 Viewer)

sumdumgai

Registered User.

June7

AWF VIP

sumdumgai

Registered User.

June7

AWF VIP

The_Doc_Man

Immoderate Moderator

arnelgp

..forever waiting... waiting for jellybean!

June7

AWF VIP

arnelgp

..forever waiting... waiting for jellybean!

June7

AWF VIP

sumdumgai

Registered User.

Similar threads

Users who are viewing this thread