Hi Steven811,
I'm not making the connection between the form, the obdc (whatever that is), the customers worksheet.
Is it possible to post a link to an example workbook to show what needs to happen to add new records to the data validation sources. I assume there are more than one data validation drop down you are using.
You can use one of the link utilities to post a link, you cannot attach a workbook in this forum. I use Drop Box, but there are others.
Howard