Variable error

[deepaksharma]

I want to say that I want to make the Access program so strong that when any unknown user uses this program, he should not face any kind of access generated error, even if he sees an error, the same see the error that is entered in the coding.

[mike60smart]

In your current process no errors are generated.
If you do get an error message it is usually to do with poor VBA Code.
If an error occurs then you resolve it before moving on.

[Welshgasman]

I want to say that I want to make the Access program so strong that when any unknown user uses this program, he should not face any kind of access generated error, even if he sees an error, the same see the error that is entered in the coding.

You have your work cut out for you then.

[deepaksharma]

But this is a error message "you tried to assign the null value to a variable that is not a variant data type"

[Minty]

When you type a space " " into a bound text control, Access will normally strip it out similarly to when you add a space to the end of any text in a bound textbox control.
It's the default behavior on an Access form.

So you need to either make that control or variable accept a null value, or make the table accept a null value.
Alternative is to replace the null value with a non null value, e.g.

If IsNull(Me.mytextbox) then MyVariable = " "

You have been told this in at least 3 different ways.

[deepaksharma]

now i get your point....

[deepaksharma]

what is the main change you have done to solve this error?

[deepaksharma]

Mike Sir,
Your method is working :-)
but i don't understand where i made mistake ?

[deepaksharma]

Hello mike,
I designed this program back as you suggested, I removed the devalut value from zero in the property of cast code in the main data file and made it no in the index.
Now when I create this program with query then the same problem comes and if I design the form by making table relationship like you then the problem is solved.
Please tell what is the difference between designing a form by creating a query and a table relationship?