I have made several changes most of them suggested by others...I still
can not get the data to submit. I keep getting the same error. I have
other forms being submitted to my database. Does anyone see anything
that I am over looking?Thanks
I could bind each field to the database but I need the info in one
column. The only way I could make sense of it is to update everything to
a hidden field and bind the hidden field to the database. What my hope
is that once the info is successfully in the database we can use a
Helpdesk program and see the Form information in the Description of the
problem.thanks
My plan is to take every field on this form and submit it to one column
in sql. In order to do this I have created an "AllFields" field on the
form for everything to update to. I will eventually hide the "AllFields"
field.Brad
I plan on submitting it to a sql database. Here is the reason that I
don't want the Nulls. I have subform1 with to radio buttons. I have the
buttons set so only one can be selected (within the subform) at a time.
I want to be able to tell by looking at a sql query which one was
checked.Brad
Now that I have the information going to one field, How do I eliminate
the "Null" fields from showing up? I'm sure its by validation of some
sort but I'm not sure how to do that. I only want to see the fields that
have information is them.ThanksBrad