New Record in Sub Report

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

Guest

I have a form that has a subform that is not visible when the form is opened.
When the user clicks a button I would like the subform to become visible and
in the mode to enter a new record. I tried coding the subform for the on load
event to be me.newrecord but got the error: Compile error: Invalid use of
property.

Thank you.
 
the NewRecord property of a form rather than a method by which to move to the
new record. Try:

DoCmd.GoToRecord , , acNewRec

Note the commas to indicate optional argument that are not required if run
in the required form.

Hope this helps

accessjunky
 
Sorry - lost the first bit of the post somehow. Should have read:

You have referred to the NewRecord property of a form rather than a method
by which to move to the new record. Try:

DoCmd.GoToRecord , , acNewRec

Note the commas to indicate optional argument that are not required if run
in the required form.

Hope this helps

accessjunky
 
Back
Top