Re: Form Requery Not Working

try using refresh and not requery. This works for me.

If CurrentProject.AllForms("Frm_Main_Menu").IsLoaded Then Form_Frm_Main_Menu.
Refresh

Mrstacy wrote:
The following code does not requery main menu. Any help is
appreciated.

Private Sub Form_Close()
If Me.Dirty Then
Me.Dirty = False
If CurrentProject.AllForms("Frm_Main_Menu").IsLoaded Then
Forms![Frm_Main_Menu].Requery
End If
End If

End Sub

Access 2003
Windows XP SP3

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Quick Search Combo Box
    ... Thanks for the hint on the location of the macro action, "refresh." ... Private Sub Combo15_AfterUpdate ... Dim rs As Object ... Dim stDocName As String ...
    (microsoft.public.access.forms)
  • Re: Quick Search Combo Box
    ... I can tell you that "refresh" isn't directly in the ... Private Sub Combo15_AfterUpdate ... Dim rs As Object ... Dim stDocName As String ...
    (microsoft.public.access.forms)
  • Re: Refreshable Stock Watcher
    ... > c) Some links never refresh. ... > a) This does not trigger a sheet change event, ... Added CCRP Timer: ... > Private Sub Timer1_Timer ...
    (microsoft.public.excel.programming)
  • Re: combine codes
    ... The subform which is continuous has a checkbox "Delivered" on each line item ... The Requery method reloads all of the form's data from its ... Refresh only checks if any of the ... Private Sub Location_AfterUpdate ...
    (microsoft.public.access.modulesdaovba)
  • Re: Listbox populating progmatically
    ... append to a typed list within the macro and not within the listbox. ... By playing with AddItem and RemoveItem I noticed when I refresh the ... XP Pro ... Private Sub UserForm_Initialize ...
    (microsoft.public.excel.programming)