hiding a control box

[markjkubicki]

I have a form with a combobox that is not always visible; it is made visible when a user clicks a command button (otherwise, it is not necessary, and it's being visible would clutter the form's design...). once a value is selected, a subform is opened (with a different form for each of the combobox's values...) and concurrently, the combobox ought to be made visible = false

however, it is not necessary for the user to select a value from the combobox (the command button may have been clicked in error, or the user may have changed their mind)

where would I put a comand to return the visible value back to false?

I thought it would have been On Lost Focus or On Exit; but neither of these seem to be right (?)


also, when when the user has clicked on a different control on the form, signaling that they no longer have interest in the combobox, and I would presume have set focus elsewhere... either the Lost Focus event does not fire (the user may not have ever given the control focus), or I cannot set visible to false for a control that has focus (?)

many thanks in advance,
mark

[ranman256]

You could put a TOGGLE button.
its. Button that stays in until pressed again.
in.
CboBtm.visible = TglBtn.value
sub.visible= ...

[knarfreppep]

Have you considered using the form's OnTimer event?

[June7]

I say if the user is given the option to reveal the combobox and they do so inadvertently, then they have option to ignore it. First you give user some power and then you want to take it away. Either fully automate availability of the combobox or just put it there and educate users on its use. Conditional Formatting can manage if combobox is enabled or not (greyed out).

Is the combobox really 'clutter' or is the button? Visible or not, the combobox still occupies space but the button is left visible all the time. That's two controls where there could be only one - always visible combobox.

[markjkubicki]

exactly what I needed
BIG thnx

http://www.blueclaw-db.com/access_ev...ming/timer.htm