Requery and Navigation

G

Guest

Background: I have a Main form frm1 which contains 2 subforms sfm1 and sfm2.
On frm1 I have a command button which opens - another form - frm2 which
allows me to add a record to the date table. The date table's data is
displayed in sfm1 on frm1.

Problem: I can do a Form!frm1.requery from the unload event of frm2 but I
can't do any form of record navigation

Question: is there a way to navigate to the last record of the form sfm1.
Below is the code i have tried.

Forms![frmMainWorshipSchedule].[sfmServiceTimeDateNotes].SetFocus
DoCmd.GoToRecord , , acFirst
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acPrevious, 5
DoCmd.GoToRecord , , acNext, 5
 
G

Guest

Hey I got it to work using this.

Forms![frmMainWorshipSchedule].[sfmServiceTimeDateNotes].Form.Requery
Forms![frmMainWorshipSchedule].[sfmServiceTimeDateNotes].Form.Recordset.MoveLast
Forms![frmMainWorshipSchedule].[sfmServiceTimeDateNotes].Form.Recordset.Move
-5
Forms![frmMainWorshipSchedule].[sfmServiceTimeDateNotes].Form.Recordset.Move 5
 

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

New record in subform 3
Change data and form crashes Access 3
Help with Requery 2
Repost: Requery Subform 3
Filtering Records Problem 1
How do I move focus to a control in a nested subform ? 2
Problem DoCmd.GoToRecord with tabbed pages 1
Combining code isn't working 5

Top