Changing focus on an active form

[accessisnew]

I have a VBA module that populates controls in an unbound form with data from a table. The module then opens the form which also contains a visible/enabled command button (Command1)that the user clicks to send selected lines from the form (user clicks check boxes to indicate which lines)back to the module for additional processing.

I want to disable the active command button (Command1) and make it invisible so that I can redisplay the form with additional data and a second command button (Command2) visible with the focus on a text field (Text1). The SetFocus and GoToControl will not allow me to change the focus from the first command button.

What can I do to change the focus to the text field (Text1)?

 

[randy700]

You cannot set focus on an object that is not set to visible. Check the order in which you are issuing the commands. Assuming that, when you first open the form, Command2 is not visible and Command1 has the focus:

1st - make Command2 visible.
2nd - set focus on Command2.
3rd - make Command1 invisible.


Randy

 

[accessisnew]

Thanks so much! The proper sequencing worked like a charm.