Sorry about the lack of clarification. I need the entire recordset to be
able to accept null values so that when I update it, I don't get the error:
Run-time error '3314': The field cannot contain a Null value because the
Required property for this field is set to True. Enter a value in the
filed.'
I can't find how to set the Required property for the recordset to False.
Should it be at the end of this statement somewhere:
Set rst = dbs.OpenRecordset("tbl")
When I go to write the recordset to a table, it won't have null values. But
when I am updating the recordset and doing calculations on it, it sometimes
will. So I don't need the table to have the ability to have Null values,
just the recordset.
Thanks, marie
"Modest Marsupial" <Ma*******@mbg.com> wrote in message
news:10*************@corp.supernews.com...
What is the DAO method of allowing a recordset to have null values?
Thanks,
marie