Not In List

[Guest]

Hello

Using a form to import data for two related tables I had set the “Requiredâ€
property of the tables’ fields to “yes†in order to force the user to put
data in every field and avoid the known problems coming from Nulls.
Later on when I decided to use the Not In List event to prompt the user
within the form to fill data for items not in list, I‘ve found that I had to
change the “Required†to “no†in order to have the Update query work
properly. That had to be done since when the event was triggered only one
field value was given.
Since I want to use the Not In List event but I don’t like to have records
with nulls, can you suggest any method that resolves the problem.
I don’t know if it is important to give the tables details but I think it
worth to mention that some fields are strings and some numerical.

Thank you
GL

 

[Guest]

Set default for the tables even if you need to default to today's date or add
a dash in a text field. The you can test the form for dashes and today's
date to see if those fields need updating.