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
 
Woops!

Typed too fast.

Me.MyCombo.Locked = Not Me.NewRecord

Sorry,
Brian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list 4
Drop down list 8
Controls on drop down lists 2
Drop Down Lists 1
Help with form drop downs 1
Pop-up form when a certain value is chosen 0
Multiple bound fields in a drop down list 2
Multi Drop Down Field Lookup 1

Back
Top