Open to new record???

  • Thread starter Thread starter Rick's News
  • Start date Start date
R

Rick's News

How do I get my subform to open to the new record???

Thanks in advance!

Rick
 
In the subform's class module:


Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub
 
How do I get my subform to open to the new record???

Thanks in advance!

Rick
Click to expand...

Two ways:

- Open the Form properties of the subform, and set its Data Entry
property to True. This is a bit limited: it lets you add new records
but will not allow you to see old records.

- Or, put a line of code in the main form's Current event:

Me!subformcontrol.Form.GoToRecord acNewRecord
 
Thanks Sandra!


Sandra Daigle said:
In the subform's class module:


Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

Rick's News said:
How do I get my subform to open to the new record???

Thanks in advance!

Rick
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Going to first record 0
Unremovable horizontal scroll bar on subform 1
New Parent Record from Navigation Buttons 2
Force Autonumber to generate 0
subform - new record entry 3
Command button to put subform into "new record" mode? 3
Subform with no records 8
Macro doesn't work first time form is opened. 2

Back
Top