Hi,

I have a contact db with Combo boxes for the Suburb and Post Code fields which automatically look up info in a table and inserts state, country etc into the form.

However, when I go to enter the next record, the two combo boxes have the info in them from the previous record. How can I start with a 'clean' form each time???

Thanks for your help.

Dave

Try YourComboBoxName = null

David

Hi,
Thanks for your quick reply http://www.access-programmers.co.uk/ubb/smile.gif

Where do I put that code?
I already use the 'afterupdate event' to automatically insert address info based on the data entered. I tried putting your code at the end, but it of course left the field blank before I could save it.

thanks David