Hi,
I'm working on a form that is conditioned to a read only user property. My question: Is it possibe to apply the GoToRecord Cmd to a subform which is disabled?
Here's what I have been playing around with:
If Forms!MainScreen!Read_Only = True Then
Forms!MainScreen!MySubform.Enabled=True
Forms!MainScreen!MySubform.Setfocus
DoCmd.GoToRecord acDataForm, Forms!MainScreen!MySubform, acNext
Forms!MainScreen!Command1.Setfocus
Forms!MainScreen!MySubform.Enabled=False
Else
<Rest of my Code>
End if
For some reason the acNext command does not want to work and the subform remains enabled after execution.
Any ideas out there?
jmc014
I'm working on a form that is conditioned to a read only user property. My question: Is it possibe to apply the GoToRecord Cmd to a subform which is disabled?
Here's what I have been playing around with:
If Forms!MainScreen!Read_Only = True Then
Forms!MainScreen!MySubform.Enabled=True
Forms!MainScreen!MySubform.Setfocus
DoCmd.GoToRecord acDataForm, Forms!MainScreen!MySubform, acNext
Forms!MainScreen!Command1.Setfocus
Forms!MainScreen!MySubform.Enabled=False
Else
<Rest of my Code>
End if
For some reason the acNext command does not want to work and the subform remains enabled after execution.
Any ideas out there?
jmc014