Variable error

[deepaksharma]

By downloading the file from this file link, when you open the admission form and click on the box of the cast and tab by giving 1 space, then 1 error is shown.
"you tried to assign the null value to a variable that is not a variant data type."


What is it and how can it be remove https://drive.google.com/file/d/1VEA...w?usp=drivesdk

[Welshgasman]

Most people will not download files from external links.
Your variable is not declared as a variant. That is the only data type that can hold a Null.
So make sure it is not null by using the NZ() function to replace it with soimething that is not null, or find out why you have the null in the first place.

[moke123]

using the NX() function

Typo Gman?

NZ()

[Welshgasman]

Typo Gman?

NZ()

Yep.
Now corrected. Thanks.

[deepaksharma]

i don't understand what event to write...?

[mike60smart]

Hi
See the attached.
I renamed some of the fields in both tables

[deepaksharma]

Very Good
Sir I use code instead of micro can i write any cod instead?

[mike60smart]

No code used at all in my process

[deepaksharma]

yes, you are right but i want to use code. is it possible?

[mike60smart]

Code to do what?

[deepaksharma]

if click on the box of the cast and tab by giving 1 space, then message will show "Please select cast" and cursor focus on cast box.

[deepaksharma]

and i don't have much knowledge about macro

[mike60smart]

Why would you put a space in the Cast Combobox.
The Combobox is designed so that you select one of the Cast's Listed.
If the Cast is not in the list then you can use Code to add to the List

[deepaksharma]

Sir, I completely agree with your point but giving space somewhere and showing this error is also an error somewhere and I want to give it a professional look in which I am taking into account even the smallest error.

[mike60smart]

Sorry I am not understanding what it is you are referring to.