visable property

[amfroehlich]

I have a drop-down list saying how many approvals are required. Whatever number is selected is i make those controls visable. How can I say if controls have a value those controls should be visable if they don't they should not be visable?

Thanks

 

[mdmilner]

I'm slow, not sure I follow what you're describing.
Are you selecting a number from your pull-down list? And if you select 5, then 5 boxes show up?

Controls on a form, including text box controls can be referenced easily with the format of Me.textbox1 - You can reference the value held in the textbox with Me.textbox1.Value. Bound controls (if the form is bound to a recordsource like a table, also allow you to reference fields using the format of Me.fieldname1.Value.

Latter is relevant because if fieldname1 is held in textbox1 on the form, it is sometimes easier to reference by the fieldname (and the recordsource object).

What I'd suggest is this.

In the _AfterUpdate event for the Combobox (where you select the number of approvals), have your program read the new value and loop through your available text boxes. This could be very simple - if you need 5 text boxes, have it count and open the first five.

Mike