Record Navigation which throwing an error in sub form control

[selvakumar.arc]

Hi,


I have a user input page in my application which consist of few text box and a sub-form. In main form I have "Save and Next" button, once the user enter this button will save the current record in database and ready for next user input. The problem here is I am unable to access the sub-form control after saving the records. I have attached the code here.

Private Sub SaveNext_Click()
Me.Refresh
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End Sub
Private Sub Form_Close() 'trying to unhide the sub form control, throwing error
Me.AnswerOptions.Form![AnswerOptionCodes].ColumnHidden = False '//Here I am getting an error Run-time error 2455. You entered an expression that has an invalid reference to the property Form/Report.
End Sub
Private Sub Form_Load() 'trying to hide sub for control, working fine
Me.AnswerOptions.Form![AnswerOptionCodes].ColumnHidden = True
End Sub

Regards,
Selvakumar R

[June7]

You want to unhide a column in the subform before closing the form? The issue may be the subform is already closed and unavailable. Try code in the subform Unload event.

Why do you bother unhiding that column when you automatically hide it in Load event?

[selvakumar.arc]

User wants to enter information continuously, so implemented "save and next" in this page and this is working as expected. But only issue is the run-time error in unhiding the controls in the sub form. And my form contains a list of text box and a sub form, like one to many relationship (pls consider a student related to different department).

Based on page functionality I want to hide only one control during the form load which is not relevant to that page and unhide it in closing the form, because the same sub form is using in another page.

This is continuous input form and allows user to enter data continuously without closing the form.

As per your comments I will write code in unload event and let you know the updates.

[selvakumar.arc]

Hi June7,
I written unhiding code in form unload event and it is working. Thanks alot for your help...

Regards,
Selvakumar R