Visibility Set to True, False Automatically

[frog40]

I have two pages to work with (for now). The first page uses a Macro to go to Page 2. This Macro sets the Focus for ComboBox1 on Page 2. (Visibility is set to True)

On Page 2, the first thing I want to happen is to set the visibility for ComboBox1 to False. I cannot make this happen. Since the focus was pre-set to this ComboBox, I used "Me.Visibility = False". This did not work. I do not want any user activity to do this.

I might mention that each Option button (3 altogether) will have it's own ComboBox. I will need to set them all to False until an Option Group button is selected. Then, only the matching ComboBox visibility will be automatically set to True.

 

[TheAceMan1]

How are ya frog40 . . .

[blue]You can't hide a control while it has the focus![/blue]

You need to set the focus elsewhere then hide the combo . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[maxhugen]

There are a couple of suggestions on setting focus elsewhere near the end of this post:

http://www.tek-tips.com/viewthread.cfm?qid=1384916

Max Hugen
Australia

 

[frog40]

Sorry about the duplicate question. I found the thread you suggested. I will give it a try. Thanks a bunch.

 

[Melagan]

'Me.Visibility = False' would set the form's visibility property, no?

Me.[i]ControlName[/i].Visibility = True|False

~Melagan
______
"It's never too late to become what you might have been.

 

[frog40]

Yes Melagan, you are correct. The problem I had was setting the focus. The suggestion on the Forum listed above sets the focus by using a dummy text box works great.