Having a blank, new record for entry when you open a form

[Dave Eliot]

I have a Command Button on my Members Form that opens a Payment Form. What I
need is a blank, new record for data entry when the Payment Form opens. I've
tried a macro to go to new record on On Open, On Load, and On Got Focus.
None of those work. Any help will be appreciated.

 

[Al Campagna]

Dave,
Use the Click event of your button, to open the Payment form... and... go to a New
record.

Private Sub YourButtonName_Click()
DoCmd.OpenForm "frmPayment"
DoCmd.GoToRecord , , acNewRec
End Sub

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Steve]

Open your payment form in design view. Open properties and set the DataEntry
property to Yes. Your payment form will always open to a new record.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Dave Eliot]

Works like a charm. Thanks so much.

Dave,
Use the Click event of your button, to open the Payment form... and...
go to a New record.

Private Sub YourButtonName_Click()
DoCmd.OpenForm "frmPayment"
DoCmd.GoToRecord , , acNewRec
End Sub

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Dave Eliot]

Thanks for your help. This works; however, I'm not able go back to a
previous entry which is a helpful. I have saved this info for future needs.
Thanks again.

Open your payment form in design view. Open properties and set the
DataEntry property to Yes. Your payment form will always open to a new
record.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Steve]

Another thing you can do is click on the far right navigation button at the
bottom left of the screen. That will take you to a new record.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Thanks for your help. This works; however, I'm not able go back to a
previous entry which is a helpful. I have saved this info for future
needs. Thanks again.

 

[Keith Wilby]

Another thing you can do is click on the far right navigation button at
the bottom left of the screen. That will take you to a new record.

"What I need is a blank, new record for data entry when the Payment Form
opens."

Yeh, great solution.

 

[Guest]

Steve, great solution, simple to use.
Thank you for posting!!
--
Thanks for being of assistance

Open your payment form in design view. Open properties and set the DataEntry
property to Yes. Your payment form will always open to a new record.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)