Problems with a the GoToRecord Cmd

[jmc014]

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

 

[lameid]

Without really understanding your purpose, this might help...
Use a wizard to make a combobox that filters by selection. Note the Use of bookmark and recordsetclone and investigate in help. That navigation method might help.