The sales dept enter records via form. This form displays the data from the odbc source that populates the worksheet called customers. It is the customers worksheet that is supplying the records with data validation in place but, what if I want to add new records via the form.
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.