From Form to Table

[mcashe]

I have a newbie question. I have a form with a few combo boxes which the control source is a field from a table (i.e. PositionTitle) When I load the form and select value (i.e. Software Engineer) from the combo box, the value that I selected isn't shown in the table. Instead, the actual row source (i.e. Employee_Pay_Information which is the table Name) is displayed instead of the value (Software Engineer) I selected in the drop-down box. Can someone please help!!

 

[haj1503]

Hi mcashe,

I can't explain what actually that you need, but if you don't care could you give me the sample at least I can understand in real case.

hopefully you understand what I need.

Best regards,

 

[Idjit]

Is it possible that you are confusing the Control Source with the Row Source?

Can you be a little more specific about how you have things set up and what you're trying to do? If you list the relevant table and field names and what you want the combo box to do it'll be easier to answer your question. Are you trying to get the combo box to look up a value in one table and store it in a field in a different table?

 

[Rich]

Have a look at some of the examples provided by Microsoft, Orders and Northwind to get an idea of how look up tables and combo boxes work. Since position title already exists in one table, you do not need to store it again in another table, only the PK from the lookup table, which becomes the foreign key in your main table.