Save button instead of navigation bar?

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

Guest

Hello -

I have a user who wants his team to use a save button for each record and
not have a navigation bar. How would I code that so it goes to a new blank
record after saving? Should I use two buttons; one for save and one for "new
record"?

What's the best way for a user to go back to a record if they want to change
something? Provide some sort of search button?

I've usually set these things up so they could page through the records.

Any help will be greatly appreciated!
 
Build a command button that adds a new record. Use this as your save
botton. The Wizard should help you build it, it's a default choice,
but if not, here's the code:
Private Sub Command8_Click()
On Error GoTo Err_Command8_Click


DoCmd.GoToRecord , , acNewRec

Exit_Command8_Click:
Exit Sub

Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click

End Sub


You can also disable the default navigation buttons on the form. Then
build additional buttons for forward or backwards a record. Again,
they're default choices in the wizard.
 
Back
Top