Open Form ready for new record

[spectraflame]

I have a button that when pressed opens a specific form. Each time I press the button, it opens the correct form, but it opens to the first record of the table.

Is there a way to have it open to the next available record so that I do not have to scroll through the records that are already in the database?

Thanks,
Matthew

 

[garyd1234]

docmd.goto acNewRec

 

[spectraflame]

Would this code be placed in VB?

Still trying to learn Access. Sorry.

This is the code that is assigned to the button that I have opening the form.

stDocName = "Electric Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Would your suggestion be added somewhere in here?

Matthew

 

[bat17]

DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd
will open the form for data entry but existing records will not be available to view. If you need the records available to look at, but want the form to open on a blank record, then you will need to add docmd.goto acNewRec to the open event of the form that you are opening.

HTH

Peter

 

[spectraflame]

Thanks to all - that was exactly what I was looking for.

Thanks again,
Matthew