Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restrict comboboxes info change after record saved

Status
Not open for further replies.

Luzbel

IS-IT--Management
Apr 20, 2007
45
PR
I have a subform with a record that contains 3 comboboxes and a couple of text boxes (hidden and visible) and an “Available” checkbox. I am trying to restrict the user to modify the records after they have been entered them; using only the “Available” checkbox if they do not want to use that record. The subform shows all records in the same page.
What I want to do is let the user select, enter the info on the record line and after the record has been saved not let the user make any changes to the 3 comboboxes. The user should be able to insert a new record.
Been trying to use locked but it locks the combobox on a new record.
 
Lock the controls in the current event procedure of the subform only when Me.NewRecord = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top