Autofill From Combo to Text Box Questions

[andtrds]

Hi all

I use a form that has a combo box and a text box.The combo box values are
Email,Cna,Dna.I manage to make users to select values from combo box and show it in the text box.I want to ask if it is possible when user select "Cna" and "Dna" from the combo box the same will appear to text box but the text box will be locked.If you choose email it would be enable.

Thanks

 

[Luddite Lad]

If I've understood your question correctly; all You need to do, is put a logical test (based on the value of the Combo Box) in the after update event for the Combo Box. Then assign a value to the text box or unlock it to allow data entry depending on the result.

 

[KingRudeDog]

An If...Then or a Case Select...

 

[Luddite Lad]

I'd just use an If...Then