Saving info from a form

[Guest]

I have a customers field on a form that has customer names in a combo box
that is coming from a select query. I would like to be able to enter new
customer names directly into the form and have those names saved in the combo
box, so next time it would be available to select on the form. right now,
the only way to add new customers to the combo box is to add the name into
the table.
thanks

 

[Guest]

Hi,
a combobox has a notinlist event...use that to add your values to the
underlying datasource.
You can find detailed information here:
http://support.microsoft.com/?kbid=197526
BTW...forms hold controls...fields are in tables.
HTH
Good luck