Accept on the fly text on a combobox tha is a lookup field

V

verci

HI

I've created a combobox tha get its datasource from a lookup field in my
orders table tha has a one to many relationship with the clients table, so
when I want to pull the clients information for printing my invoice I just
press te combo box select my client name and voila, my problem is tha this
field wont let me enter the clients name if is not in the clients table, how
can I achieve this functionality, to be able to enter the clients name on
the fly.

Thanks, regards
 
D

Douglas J Steele

Don't use a lookup field. Use a combobox on a form, and use the combobox's
NotInList event to allow you to add the new client name.
 
Top