Guys,
I have a form/subform setup where the main form uses a child subform to check if a 'code number' has already been changed. The subform is based on a query, and if the code selected from the parent is not present on the child form, then I get the 2427 runtime error due to NULL value.
I totally understand why its generating the error, the question is how do I get past it. I want a text box on the main form to return "n/a" if the null condition occurs, otherwise populate with the value found on the child form.
If this is not clear then I can try and explain more if necessary!
Thanks in advance.
Cheers, Supanoods B-)
"If it aint broke - dont fix it!
I have a form/subform setup where the main form uses a child subform to check if a 'code number' has already been changed. The subform is based on a query, and if the code selected from the parent is not present on the child form, then I get the 2427 runtime error due to NULL value.
I totally understand why its generating the error, the question is how do I get past it. I want a text box on the main form to return "n/a" if the null condition occurs, otherwise populate with the value found on the child form.
If this is not clear then I can try and explain more if necessary!
Thanks in advance.
Cheers, Supanoods B-)
"If it aint broke - dont fix it!