Navigating To A Control in a subform

[CharlieT302]

Hi Folks,

I have a main form called "main." It has a subform called Subform1. Subform1 has a subform called Subform2.

Main
Subform1
Subform2

While in Subform1, I have a button that is supposed to go to a field called "Remote" on subform2 when there is an error.

Here is what I have done. The focus never actually goes to the field.

If Err = 3200 Then
Me![Subform2].Form![Remote].SetFocus

Any Ideas?

 

[PHV]

And this ?
If Err = 3200 Then
Me![Subform2].SetFocus
Me![Subform2].Form![Remote].SetFocus
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CharlieT302]

Well that was just too simple. Thank you, I really appreciate it.

 

[CharlieT302]

One more problem,

I am using the code you and I discussed to select related records for deletion. Once the focus is obtained in the subform, the record is deleted. This works fine. However, if the user cancels the delete action, it generates a runtime error 2501; a second error message. I would like to simply cancel this message.

The problem is that the code from the above message is already using the "On Error" command. How can I tell the program to ignore the second error? Below is the actual code I am using.

On Error GoTo Error_Delete

DeleteRecord:
DoCmd.RunCommand acCmdDeleteRecord

Error_Delete:
If (Err = 3200) Then
Me![frm Provider Provisions].SetFocus
Me![frm Provider Provisions].Form![RemoteM].SetFocus
DoCmd.RunCommand acCmdDeleteRecord
Response = acDataErrContinue
End If