Combobox and error 3314

[Hallgeir]

I have a combobox bound to a field where the Required property is set to
True. When I delete value in combobox field and press enter I get a system
message telling me that I need to have a value in that table and that
tablefieldname. I understand that this state requires a message but is it
possible to supress the system message and instead write my own? And how
could that be done. Appreciate any tips.

regards Hallgeir

 

[Jeanette Cunningham]

Keep in mind that I don't know anything about your tables, relationships and
database when reading the answer below.
It may be easier if you change the table properties for that field in the
table.
Instead of Required = Yes,
Use a validation rule of Is Not Null.

You can usually use the before update event of the form to check for null
values and ask the user to make an entry for those fields.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia