Forms and Subforms Help

[mary]

I am having problems . Please Help. I have an Access 2002 db. One master
form with 2 subforms. If the value in a control = 9 I would like the focus
set to a control in the subform. Sometime it works other times it doesn't. I
keep getting GoToControl is not available.
An example of the code:
If Not IsNull(Me!htDt) Then
DoCmd.GoToControl "subFrmWtBp"
DoCmd.GoToControl "visitNum"
End If
I have also used Me.Active Control with the same results.
Thanks in advance for any and all help.

 

[Sandra Daigle]

Try using the setfocus method instead of DoCmd.GoToControl:

If Not IsNull(Me!htDt) Then
me.subFrmWtBp.setfocus
me.subFrmWtBp.form.visitNum.setfocus
End If

 

[mary]

Please clarify ......... "address of your subFrm". What does this mean.

 

[mary]

I tried this:
The first time everything appears to be working. The next time I enter a
record with similar conditions I get a message 'Can't move the focus to the
control '
Any other suggestions?

Try using the setfocus method instead of DoCmd.GoToControl:

If Not IsNull(Me!htDt) Then
me.subFrmWtBp.setfocus
me.subFrmWtBp.form.visitNum.setfocus
End If



--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I am having problems . Please Help. I have an Access 2002 db. One
master form with 2 subforms. If the value in a control = 9 I would
like the focus set to a control in the subform. Sometime it works
other times it doesn't. I keep getting GoToControl is not available.
An example of the code:
If Not IsNull(Me!htDt) Then
DoCmd.GoToControl "subFrmWtBp"
DoCmd.GoToControl "visitNum"
End If
I have also used Me.Active Control with the same results.
Thanks in advance for any and all help.

 

[Sandra Daigle]

Is the control always visible? What about the subform? What events are you
using to do this?

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I tried this:
The first time everything appears to be working. The next time I
enter a record with similar conditions I get a message 'Can't move
the focus to the control '
Any other suggestions?

Try using the setfocus method instead of DoCmd.GoToControl:

If Not IsNull(Me!htDt) Then
me.subFrmWtBp.setfocus
me.subFrmWtBp.form.visitNum.setfocus
End If



--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I am having problems . Please Help. I have an Access 2002 db. One
master form with 2 subforms. If the value in a control = 9 I would
like the focus set to a control in the subform. Sometime it works
other times it doesn't. I keep getting GoToControl is not available.
An example of the code:
If Not IsNull(Me!htDt) Then
DoCmd.GoToControl "subFrmWtBp"
DoCmd.GoToControl "visitNum"
End If
I have also used Me.Active Control with the same results.
Thanks in advance for any and all help.

 

[mary]

Control and subfrm are always visible. I am doing this in the onExit event
Thanks
Mary

Is the control always visible? What about the subform? What events are you
using to do this?

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I tried this:
The first time everything appears to be working. The next time I
enter a record with similar conditions I get a message 'Can't move
the focus to the control '
Any other suggestions?

Try using the setfocus method instead of DoCmd.GoToControl:

If Not IsNull(Me!htDt) Then
me.subFrmWtBp.setfocus
me.subFrmWtBp.form.visitNum.setfocus
End If



--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


mary wrote:
I am having problems . Please Help. I have an Access 2002 db. One
master form with 2 subforms. If the value in a control = 9 I would
like the focus set to a control in the subform. Sometime it works
other times it doesn't. I keep getting GoToControl is not available.
An example of the code:
If Not IsNull(Me!htDt) Then
DoCmd.GoToControl "subFrmWtBp"
DoCmd.GoToControl "visitNum"
End If
I have also used Me.Active Control with the same results.
Thanks in advance for any and all help.

 

[Sandra Daigle]

I'm not sure what might be happening unless there is another event that is
conflicting (ie a form BeforeUpdate event perhaps?) - try moving the code to
the AfterUpdate event of the control and see what happens.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Control and subfrm are always visible. I am doing this in the onExit
event Thanks
Mary

Is the control always visible? What about the subform? What events
are you using to do this?

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

I tried this:
The first time everything appears to be working. The next time I
enter a record with similar conditions I get a message 'Can't move
the focus to the control '
Any other suggestions?


:

Try using the setfocus method instead of DoCmd.GoToControl:

If Not IsNull(Me!htDt) Then
me.subFrmWtBp.setfocus
me.subFrmWtBp.form.visitNum.setfocus
End If



--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


mary wrote:
I am having problems . Please Help. I have an Access 2002 db. One
master form with 2 subforms. If the value in a control = 9 I would
like the focus set to a control in the subform. Sometime it works
other times it doesn't. I keep getting GoToControl is not
available. An example of the code:
If Not IsNull(Me!htDt) Then
DoCmd.GoToControl "subFrmWtBp"
DoCmd.GoToControl "visitNum"
End If
I have also used Me.Active Control with the same results.
Thanks in advance for any and all help.