Protect Data in a Combo Box

T

TheSearcher

Registered User.
Local time
Today, 04:47
Joined
Jul 21, 2011
Messages
404
I have a combo box using a query for a rowsource. I have the "Limit to List" property set to Yes and the "Allow Value List Edits" property set to No. But the user can still change or delete the data - and this causes the program to crash. If I set the "Locked" property to Yes then nothing can be selected. What can I do to protect the data in my combo box?

Thanks,
TS
 
Use the BeforeUpdate event to qualify the changes.
 
use the NotInList event of the combo:

Private Sub combo_NotInList()
Response=acDataErrDisplay
end sub
 
TheSearcher said:
...But the user can still change or delete the data...
Click to expand...

Or are you saying that the user can simply delete a selection that has been made or enter a value by typing it into the Combobox...and this is what you want to prevent?

Linq ;0)>
 
Pat Hartman - The combo box is not bound to any table. It's rowsource is an sql query that executes in the "on open" event of the form.
Missinglinq - Yes that is correct. The user can actually delete the contents of the combo box leaving a null value and thereby causing the program to crash. I addressed this by putting code in both the "Before Update" and "After Update" events to check for a null value. That seems to be working.
 
You must log in or register to reply here.

Similar threads

G
Strange behaviour from a combo box on a form when trying to evaluate data in another column
Replies
6
Views
494
GPGeorge
GPGeorge
D
Solved Disable Multiple Record Selection On Subform
Replies
7
Views
253
dalski
D
HavingDatabaseRelations
Solved Combo Box will only work if Access is not minimized
Replies
10
Views
1,014
Mike Krailo
Mike Krailo
M
Solved ComboBox.ShowOnlyRowSourceValues (Access) Problem. What it do, exactly?
Replies
6
Views
994
MajP
MajP
J
Combo Box to filter and Allow Edits
Replies
3
Views
680
Gasman
Gasman

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom