How do I get a combo-box selection to show up in the table.

[FBrnstrmr]

I have a table where I need my selection from a drop down combo-box to be
placed. What is the connection between the form control and the table record
where I need it to go Oh yes does the table column have to have the Data type
display control as the combobox? Please and thank-you.
-Fred

 

[Al Campagna]

FBrnstrmr,
Your combo box control must be bound to a field in your table, in order
to capture that value for each record.
Add a field to your table named State.
Include the State field in your form's Record Source.
Setup a combo to select a state.
Set the ControlSource property for the combo to State.
Now, when you select a State for any record, it will be saved to the
table.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[FBrnstrmr]

Thanks Al, but how do I include the state field in my form's record source.
How do I edit the form's record source when I right click on the form name
and then hit properties it is just a window with a description option in it.

 

[Al Campagna]

Thanks Al, but how do I include the state field in my form's record

source.

You have a table, or more often, a query... as the RecordSource of your
form.
A table RecordSource would automatically include the new State field, but...
with a query, you'd just include the State field in the SQL statement.

How do I edit the form's record source when I right click on the form name
and then hit properties it is just a window with a description option in
it.

The properties of a form name has nothing to do with changing the
RecordSource for a form. That is done in Form Design Mode.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."