Setting Focus

[Guest]

I’m using Access 2002 and Sql 2000.

I have a form frmOfficeMovesEntry and a sub form frmOfficeMovesSub.

Within the frmOfficeMovesSub I have a MoveTo field. MoveTo has an After
Update event that that asks if you want enter another move.

My problem is when No is selected. I’m trying to set the focus to a
VerbalApproveBy field that’s on the frmOfficeMovesEntry form.

I’ve tried Me!frmOfficeMovesEntry!VerbalApproveBy.SetFocus along with other
modifications but I can’t get anything to work.

Can anyone please tell me what I’m doing wrong?

Thanks,

Paul

 

[Guest]

One of these should do it for you:
Me!Parent!VerbalApproveBy.SetFocus
Or
Forms!frmOfficeMovesEntry!VerbalApproveBy.SetFocus

 

[Guest]

Got the second option to work. I guess I tried everything but that.

Thanks for the help,

Paul