Creating a button that goes to the next new record

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am fairly new to access and i am trying to build an inventory database that
lists all our grounds maintenance equipment. I have all the records typed in
but would like a button for adding new equipment as it is purchased. Ideally
the button will take me to the next new record rather than an existing one.
What is the easiest way of doing this?
I am using Access 2003
 
At the bottom of your form, there are navigation buttons, like this:
|< < [ 5] > >| * of 77 records
The star button takes you to a new record.

If you don't see this, open the form in design view, and set its Navigation
Buttons property to Yes.

If you want to code it, you would put something like this in the Click event
procedure of your command button:
If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew
 
Back
Top