Control on form

J

jk

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?
 
S

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
*
 
Top