How to simulate clicking '>*'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way for a command button to EXACTLY simulate clicking the new
record icon '>*" in the navigation area.

Currently there is a button that attempts to do this but when the current
record is left certain validation routines run which in some circumstances
result in an Error with Err.Number = zero.
 
Is there a way for a command button to EXACTLY simulate clicking the new
record icon '>*" in the navigation area.

Currently there is a button that attempts to do this but when the current
record is left certain validation routines run which in some circumstances
result in an Error with Err.Number = zero.
Click to expand...

Does clicking >* not generate the same events? If you're leaving the record,
Access will try to save that record; ideally you would have a Form
BeforeUpdate event to validate the record and either trap the error or get the
user to deal with the problem.

What do you WANT to happen when the command button attempts to leave an
invalid record?

John W. Vinson [MVP]
 
Back
Top