How to populate selection from combo box in a table

[Lmanns]

Hello,

I have a form with Record Source TBL_Log. The form has a combo box with Row
Source TBL_Suppliers where the user must select the supplier from the combo
box. I do not want the users to manually enter the supplier because of
typos, etc.

The form also has a textbox with an autodate and some other fields that the
users will have to key information into (PO#, Invoice#, Comments, etc.).
When I test the form, the autodate, and the data entry shows up in the table,
TBL_Log. But the supplier name selected from the combo box does not.

How do I get the selection from the combo box to populate in the table,
TBL_Log although the supplier name comes from another table?? Weird thing is
I could have sworn I've done this before...

Thanks in advance!

 

[boblarson]

You set the combo's CONTROL SOURCE to be the field that you want the data
stored in. That is not to be confused with the combo's ROW SOURCE which is
the source of the combo's data that you can select from. So the row source
is the table/query that allows you to list what you want to select from and
the CONTROL SOURCE is the field in the form's bound table/query that lets you
save the selected value to the table.
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________

 

[Lmanns]

Thank you so much! Worked perfectly.

You set the combo's CONTROL SOURCE to be the field that you want the data
stored in. That is not to be confused with the combo's ROW SOURCE which is
the source of the combo's data that you can select from. So the row source
is the table/query that allows you to list what you want to select from and
the CONTROL SOURCE is the field in the form's bound table/query that lets you
save the selected value to the table.
--
Bob Larson

Free Tutorials and Samples at http://www.btabdevelopment.com

__________________________________