Hi all,

I've got a dropdown list whose recordsource is a SQL statement (type 3). It creates a cursor (contact names) which is used for the list. I'm allowing the users to enter another form to add a new contact.

What I need to do is once they've added a new record in my table being used in the SQL statement and return to the main form, is 'rerun' the SQL statement in the recordsource to update the list.

Where/how can I do this??

mtia!

Mandy