DRW has to submit value to field

[Dave Remer]

I noticed when you post info into a access database from
a form. You can cannot leave one of the form fields blank
or you get a error. I added a "Default Value" such as N/A
in the DRW and then it works, but it adds that N/A value
into the database. How can I submit a form field that is
blank and also leave the database field blank.

Thanks for your help
Dave

 

[Kathleen Anderson [MVP - FP]]

Check the Properties of the field in the database - if "Required" is set to "yes", change it to "no."

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/