Invalid use of null

V

vlad

When I click "Add new record" batton on my data-entry form, I receive MS
Access Error Message "Invalid use of Null".
Please help
 
F

Fritz Range

This is a common problem when you have some requirements
set in your tables that a field cannot be null. When you
open that "New Record" and you do not have something
defaulted into a field, you will get this type of error.
It could also be something that you have set on your form
when it goes to a new record. You can use vba code to go
to a new record and and "ignore" the error.
 
D

Dirk Goldgar

vlad said:
When I click "Add new record" batton on my data-entry form, I receive
MS Access Error Message "Invalid use of Null".
Please help
Click to expand...

Please post the code from the button's Click event. That may tell us
where to look for the error. The message implies that you are assigning
a Null value to a variable that cannot contain Null.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VSTO C# add in Outlook.Appointment error 0
purchasing Office 2016 on ebay 3
New Record, Invalid Use of Null 2
Invalid use of Null 3
How do I clear a form? 0
return a null value to date field 2
Run-Time Error '94' Invalid use of Null 9
Word VBA runtime error 94 Invalid Use of Null 5

Top