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
Re: How do you return to record you were working on after requery? ... I made those changes, but after the requery, it still goes back to the first ...Private Sub Combo_Answer_A_AfterUpdate ...Tempscore = Tempscore + 1 ... them with the 'AnswerA' which is offered via the Combo_Answer_A dropdown. ... (microsoft.public.access.formscoding)
Re: cascading combo boxes requery problem ... Doug I've reread the article and my form is not a continuous form.... how I want to use the merit increase form I'm trying to create. ... Also, you are doing your requery multiple times on each field, which is ...Private Sub cboQuartile_AfterUpdate ... (microsoft.public.access.forms)
Re: Subform not updating ... I've tried requery on both forms in AfterUpdate, OnExit, OnCurrent, etc and ... so I tried putting in the JobNumber field to ...Private Sub Incoming_AfterUpdate ... the JobNumber on the subform should be the same as the JobNumber on the ... (microsoft.public.access.forms)
RE: Cascading Combo Boxes in Main Form ... different list based on the selection made in the "Entity" combo box. ...requery the third combo box. ... try the following code for each of the first two combo boxes:...Private Sub Accounting_Period_AfterUpdate ... (microsoft.public.access.forms)
Re: cascading combo boxes requery problem ... the RowSource for my combo boxes. ... From the merit increase subform the supervisor selects the quartile, ... Also, you are doing your requery multiple times on each field, which is ...Private Sub cboQuartile_AfterUpdate ... (microsoft.public.access.forms)