Move Focus to Mainform

[FredaH302]

I have a delete button that selects all related records in a subform and deletes them. This works fine.

I then want to move back to the main form and delete the main record.

I have tried:
Forms![Main Form].[Field].setfocus
Me.Parent!Field.SetFocus

The commands are ignored. What is the correct syntax??

 

[PHV]

You should set the focus to the form before:
Me.Parent.SetFocus
Me.Parent!Field.SetFocus

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[FredaH302]

This is the darndest thing. It flat out will not work.

Here is my actual code:
Forms![frm_housing].Form![frm_FeatureS].SetFocus

DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdDeleteRecord

Me.Parent.SetFocus
Me.Parent!Facility.SetFocus

The subrecords are deleted fine, but the focus will not move back to the main form. I have this code attached to a command button and the subform is on a tab control - not that any of that should matter? What am I doing wrong?

 

[PHV]

And what about this ?
Forms![frm_housing].Form![frm_FeatureS].SetFocus
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdDeleteRecord
Forms![frm_housing].Form.SetFocus
Forms![frm_housing]!Facility.SetFocus

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[FredaH302]

PHV,

Actually, that was one of the first things I tried. Just for the heck of it, I tried it again with no luck. The focus will not budge from the subform. There is really nothing special about the form.

 

[FredaH302]

With patience comes reward. Specific records on the subform had no related records, which caused the delete command to bomb. The default error description was turned off so it did not return a reason. This stopped the remainder of the code from processing.

Once I accounted for the possibility of an empty related recordset, I could get the focus to move to the main form.

Thanks for your input.