|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 12th, 2009, 12:01 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Control Source for a combo box on a form
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. 
|
|
#2
December 12th, 2009, 03:16 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Control Source for a combo box on a form
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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "forest8" wrote in message ... 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.
|
|
#3
December 12th, 2009, 04:06 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Control Source for a combo box on a form
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. "Arvin Meyer [MVP]" wrote: 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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "forest8" wrote in message ... 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. .
|
|
#4
December 12th, 2009, 01:52 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Control Source for a combo box on a form
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 http://I.Am/DougSteele (no e-mails, please!) "forest8" wrote in message ... 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. "Arvin Meyer [MVP]" wrote: 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 -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "forest8" wrote in message ... 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. .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
