Button to save current record and open new record?

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

Guest

I used the command button wizard to put a Save button on my form, but I would
like my Save button to save the current record and open a new blank record.
What sort of code/query would I use to do this?

Thanks!

Jen
 
Moving from one record to another automatically saves the record. No button
required. Why not just hit PAGE-DOWN, or click the [>*] button at the
bottom of the form.
 
I know how to save records without a command button, but the Save button just
looks nicer. And I can be very picky. Is there code I can add to the Save
button to move to a new record when it is clicked?

Thanks.

Jen

Rick B said:
Moving from one record to another automatically saves the record. No button
required. Why not just hit PAGE-DOWN, or click the [>*] button at the
bottom of the form.



BadJooJooJen said:
I used the command button wizard to put a Save button on my form, but I would
like my Save button to save the current record and open a new blank record.
What sort of code/query would I use to do this?

Thanks!

Jen
Click to expand...
Click to expand...
 
I used the command button wizard to put a Save button on my form, but I would
like my Save button to save the current record and open a new blank record.
What sort of code/query would I use to do this?
Click to expand...

As Rick says, the Save button is unnecessary. If you want to use it
anyway, just add a line in its Click event such as

DoCmd.RunCommand acCmdNewRecord


John W. Vinson[MVP]
 
Back
Top