bob bisquick
Registered User.
- Local time
- Yesterday, 20:01
- Joined
- Nov 8, 2002
- Messages
- 37
I am trying to do this:
On MainMenu form, click on a button to open a new form.
On the new form there is subform. I want to open the new form with the subform on a new record.
A solution posted here often looks like this:
DoCmd.OpenForm DataEntry, acNormal, , , acEdit
Me!Subform.SetFocus
DoCmd.GoToRecord , , acNewRec
However, I get this error:
"The expression you entered referrs to an object that is closed or doesn't exist."
I am using the subform control name, not the actual name of the subform. Any thoughts?
On MainMenu form, click on a button to open a new form.
On the new form there is subform. I want to open the new form with the subform on a new record.
A solution posted here often looks like this:
DoCmd.OpenForm DataEntry, acNormal, , , acEdit
Me!Subform.SetFocus
DoCmd.GoToRecord , , acNewRec
However, I get this error:
"The expression you entered referrs to an object that is closed or doesn't exist."
I am using the subform control name, not the actual name of the subform. Any thoughts?