Yes. Exactly as the error says, you can't make a control that has the focus
invisible. So you would just use me.anothercontrol.setfocus to shift the
focus elsewhere.
Having said that, I'd suggest that in your position just to leave the
control invisible in normal design view, and then switch it to visible when
required.
Ray S. said:
When I try to do what you suggest I get "you can't hide a control that has
the focus".
Rob Oldfield said:
You could make the control invisible and then make it visible only when the
user selects a month.
Ray S. said:
I have a form with a text box that references and calculates:
=
- .[column](1,1)/
- .[column](1,0)
The user must select a month before the List populates with data, so before
selecting the month, the text box with the reference above displays "Error".
I was fiddling with the Nz function trying to figure out how to
