simple? clearing combo box fields

[Davidekreed]

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

 

[DJN]

Try YourComboBoxName = null

David

 

[Davidekreed]

Hi,
Thanks for your quick reply

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