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...
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