Link to home
Start Free TrialLog in
Avatar of Richard
Richard

asked on

null value- problem with adding a record

dbse uploaded
go to form called clients
go to first tab called main detaills

when i add A new record in the main details tab I get the error message "you tried to assign a null value to a variable that is not a variant data type."
However once i get rid of that message I can continue to add the record...

But thats not right obviously. What is wrong!
current-2-.accdb
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
May be this way
current-2-.accdb
<I don't really understand why you like to have subform if it is using same table as main form.>

Yes, Can you first take a step back and explain your design please?

Your Relationships are very confusing...

...but first see if als315's sample solves your issue.
Agree.  Linked subforms are intended for a parent child relationship, but that is not what you have. In your case, both the form and subform have the same record source.  When you add a new client, the child recordsource gets confused on the autonumber column.

Solution 1:  eliminate the subform
Solution 2:  eliminate the autonumber