COMBO BOXES

[Guest]

I have a table named tblSize. I have a form name Data. I want to use a combo box in this form to select a size. I want the size selected to be put into a field called PartSize in the source table for the form data. I do not want a 1 or 17 or whatever put into that field. I want the actual value selected i.e .078 or .08125. How do I do this? Thanks.

 

[Wayne Morgan]

Set the Control Source of the combobox to the field you want the data stored
in. Set the Bound Column of the combobox to the column that contains the
data that you want to store.

--
Wayne Morgan
Microsoft Access MVP

I have a table named tblSize. I have a form name Data. I want to use a

combo box in this form to select a size. I want the size selected to be put
into a field called PartSize in the source table for the form data. I do not
want a 1 or 17 or whatever put into that field. I want the actual value
selected i.e .078 or .08125. How do I do this? Thanks.