Hi
this is just a general question about updating tables from code.
I have a class which updates a table. The class gets its values from a function which gathers the values from a form.
If I leave one of the fields in the form blank i get an error message in the function to warn me of an invalid null. to get round this i add a line similar to..
If IsNull(.TextBox) then goto...
This solves the problem but I was wondering tho if there was another way of doing this such as a line of code that tells the function to ignore all nulls in the forms objects or do i need to add a line of code to tell the function to ignore each object.
Any advice is greatly recieved
Chris
this is just a general question about updating tables from code.
I have a class which updates a table. The class gets its values from a function which gathers the values from a form.
If I leave one of the fields in the form blank i get an error message in the function to warn me of an invalid null. to get round this i add a line similar to..
If IsNull(.TextBox) then goto...
This solves the problem but I was wondering tho if there was another way of doing this such as a line of code that tells the function to ignore all nulls in the forms objects or do i need to add a line of code to tell the function to ignore each object.
Any advice is greatly recieved
Chris