Choose from drop down list then disable field

D

debraj007

Morning! I have a drop down on my form that enables the user to pick a
particular company they are going to send the form to (save from having to
rekey over and over). Once the form is completed, how can I disable the the
drop down field so if someone goes back into that form, they can't change the
drop down to another company? Thanks!

Deb
 
B

Brian Bastl

using the form's current event

Me.MyCombo.Enabled = Me.NewRecord
or
Me.MyCombo.Locked = Me.NewRecord

This will enable/unlock the combo on a new record

Brian
 
Top