Choose from drop down list then disable field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top