Control on form

[Guest]

I have a one to many relationship on the main and subform (customers=main,
invoices=subform) and i would like to have a promt appear before the end user
is able to move on the next customer record. Is this done through a control
placed within the form?

 

[strive4peace]

Hello,

put a command button on the main form:

Name --> cmdMoveNext
OnClick --> [Event Procedure]

'~~~~~~~~~~~~
'save record if changes have been made
if me.dirty then me.dirty = false

on error resume next
DoCmd.RunCommand acCmdRecordsGoToNext
'~~~~~~~~~~~~

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*