Combo Box - Not In List code

[rochelle]

I have a combo box which selects values from the City table, to view on a Customer form.

What VBA code do I need to write in the Not In List property of the combo box to enable me to add a new item to the City table, assign the new City item a CityID (which may happen automatically) and for that CityID to be stored in my Customer table.

Currenly when I select a City already in the combo box, it automatically assigns the appropriate CityId in my customer table.

All comments/help are gratefully appreciated!

Regards,

Rochelle

 

[Travis]

You will need to run an Append Query.

 

[Jack Cowley]

Rochelle -

Take a look at this article as I think this is what you are after....
http://support.microsoft.com/support/kb/articles/Q161/0/07.asp?LN=EN-US&SD=gn&FR=0

HTH,
Jack

 

[rochelle]

Thanks, Jack - that's just what I needed!

Rochelle