Access 2000 move to a new record on a subform.

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

Guest

We have an form with a sub form and I want to make the current record be a
new record on the sub form. The catch is I need to do this from a third form.
The question is how do I reference the sub form and make the code:

DoCmd.GoToRecord acDataForm, "Form_orderdetails", acNewRec

work correctly.
I am already able to change the data in the fields on the sub form with out
any problem. (Form_orderdetails!Grade = Me!Grade)
I would appreciate any suggestions you may have.
Thanks in advance.
 
It'll be easier if you use a completely different approach. Let's tell the
recordset of the subform to start a new record:

Forms!MainFormName!SubformControlName.Form.Recordset.AddNew

where SubformControlName is the name of the subform control (the control
that holds the subform object).
 

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

Will not go to New Record in a subform. 1
Controlling a Sub Form 4
open nested subform to new blank record 1
changing mainform record from subform 3
Adding new record in tab subform 2
Add new record command button not working in tabbed form 1
Need combo box to refresh when moving to new record 2017 1
GoToRecord on a subform... 3

Back
Top