Control Source for a combo box on a form

[forest8]

Hi

On my form, I use a combo box for teachers based on a separate table.

On my form, I want to be able to add the teacher name so I created a new
combo box and use a lookup to attach it to the teachers table.

I can't get it to link the associated table for my form.

What am I doing wrong?

Thank you in advance.

 

[Arvin Meyer [MVP]]

You can use 1 combo box and use the NotInList event to add the teacher. See
my code at:

http://www.datastrat.com/Code/NotInListCode.txt

and a demo of how it works at:

http://www.accessmvp.com/Arvin/NotInListDemo.zip

 

[forest8]

Currently the table which feeds the form has the Teacher field. When I try
to choose Teacher for the source, it's not listed. but it does exist in the
table.

 

[Douglas J. Steele]

Are you sure that the table is the recordsource of the form, and not a query
which doesn't happen to include the field in question?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)