Access recordset in main form from subform

VBAWTB

Registered User.
Local time
Today, 16:24
Joined
Sep 26, 2011
Messages
30
I need to navigate the recordset in the main form from the subform. The main form displays the parent record, and the subform the child record for data to be entered. After data is entered, (in this case only one row) I need to do a .movenext in the main form recordset...preferably on the afterupdate event on the last field. Is this possible? I need help!
 
I found the answers I was looking for in a document someone posted in the code snippets section...called 'Subform Syntax' (not sure how to create a link to another thread) The VBA code I used was..

Me.Parent.Recordset.MoveNext

in the last field's AfterUpdate event.
 

Users who are viewing this thread

Back
Top Bottom