Chris wrote:
if the user doesn't complete a field or leaves a field blank
then the code comes back with an error.


Would help to know what the error was.
I am guessing that you were trying to feed a zero length string into a
table field that is set to not allow zero length strings.

If that is the case and the fields have no default value specified then

' leave Null if no value specified
if area_cbo.Text<"" Then rs!area = area_cbo.Text
if officer_txt.Text<"" Then rs!Officer = officer_txt.Text
'etc

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup