Mulitple On Dirty

[Stemdriller]

Hi all

Thought I'd done with this database, but alas, Users, don't we love 'em?

A form that has 20 or so TextBoxes in, users can quite simply fill in the textboxes they want, but when the Form closes I need the textboxes with data in to become disabled? but the textboxes without any data to stay enabled??

Thanks
Gareth

 

[spikepl]

WHat do you mean? WHen the form closes, then the textboxes are no longer visible/accessible , so...?

 

[Stemdriller]

If the user populates a textbox and closes the form, the next time the form is opened the textbox that has data is then locked or disabled, the textboxes that are still empty are available for data. Basically we are trying to stop users changing data after the initial entry

I can manage to do it for one or two textboxes but there are 20 odd textboxes per form, so some code that would check all textboxes would simplfy

 

[spikepl]

Ok, and so your specific issue is what exactly? In the other post of yours you got a recipe for a loop over your textboxes, so what are you missing?

 

[Stemdriller]

Ok, and so your specific issue is what exactly? In the other post of yours you got a recipe for a loop over your textboxes, so what are you missing?

When a form closes, a loop that looks at all the textboxes, if they are still blank then they stay enabled else Disabled