G
Guest
I have a form, frmLevel3, that is a subform of frmLevel2, that is a subform
of frmLevel1. When the user enters data into frmLevel3 and accepts the
current record, I run code to calculate and set the Default value of a field
on frmLevel3 for the next record. Setting the Default value requires I use
the requery command which then puts the record selector at the first field of
the first record. I would like the selector to move to a new record. I've
tried using docmd.movetorecord, but I can't get the syntax right.
Any suggestions would be greatly appreciated.
of frmLevel1. When the user enters data into frmLevel3 and accepts the
current record, I run code to calculate and set the Default value of a field
on frmLevel3 for the next record. Setting the Default value requires I use
the requery command which then puts the record selector at the first field of
the first record. I would like the selector to move to a new record. I've
tried using docmd.movetorecord, but I can't get the syntax right.
Any suggestions would be greatly appreciated.