Requery main form not working

T

Tucker

Hi,
I'm having troubles getiing a form/sub form to requery. Shift F9 works fine,
however...
Me. Reqery
Me.Forms![Frm_CurrentOutagesMAIN]![Frm_CurrentOutages].Requery
Forms![Frm_CurrentOutagesMAIN]![Frm_CurrentOutages].Requery and
don't seem to work on the main and sub form using Got Focus.

I have an input/update form, when this is closed the changes appear
immediately in the above Outages form. However I need the underlying query to
refresh to change the sort order and remove closed records. As this will be
used by a couple of users at the same time will it automaically requery on
every open database whenever a change is made?
Thanks for any assistance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform-on Main form not refreshing queried job list 2
List Box Does Not Requery (Access 2003) 0
Main Form / ListCount Problem 14
Listbox will not Requery AfterUpdate 5
Requery was working now is not 0
Requery a sub table 1
Requery main form after subform update and not lose place in main form. 3
When to requery main (continuous) form after adding new record 3

Top