Best way to add new record using form?

[Buakaw]

I have a combo box on a form that reads its possible selections from a table. The bound column however is the primary key, not the value that's displayed. So I can't just turn LimitToList property to No.



I basically want the user to have the ability to add a new record to this table if an entry is not in the existing list.

May I know what is the best way to do this?

Thanks.

[alansidman]

Take a look at Allen Browne's tutorial on "Not in List"

http://allenbrowne.com/ser-27.html

Alan

[Buakaw]

Thanks Alan.