B
Bob Quintal
=?Utf-8?B?U2VjcmV0IFNxdWlycmVs?=
1) change the combo to a button that opens a little form with your
combobox, and have the code to move to the chosen record reference
the main form.
2) instead of locking controls globally with the allowEdits
property, loop through the form's controls collection, setting the
locked property of controls based on a) a prefix|suffix to the
control names, or b) use the tag property of each control to hold a
value which you test to see if that control should be locked.
Pick one of the following:I'm using the "AllowEdits" to lock records so they can't be edited
unless it's a new record. I also have a combo box on my forms
header that I use to search for records. When I have the
"AllowEdits" set so records can't be edited it also locks that
combo box as well and users can't search for records for viewing
purposes only. How can I continue to lock the records and also
allow users to select a record from the combo box on my forms
header?
1) change the combo to a button that opens a little form with your
combobox, and have the code to move to the chosen record reference
the main form.
2) instead of locking controls globally with the allowEdits
property, loop through the form's controls collection, setting the
locked property of controls based on a) a prefix|suffix to the
control names, or b) use the tag property of each control to hold a
value which you test to see if that control should be locked.