Combo box on form

[Pat B]

I created a form that has a combo box based on a list of values in a table.
The selections in the table appear in the pull down box on the form but when
I close the form, the selection I made doesn't save. I want to also convert
this form to a report-will the addition of new info data entered into the
form carry over into the report automatically when I get the above problem
resolved?

 

[KARL DEWEY]

Forms do not store data.
A combo box on a form needs a source and to be bound to a table or query so
that any selection may be stored into the table under the form.
Do you follow this?

 

[fredg]

I created a form that has a combo box based on a list of values in a table.
The selections in the table appear in the pull down box on the form but when
I close the form, the selection I made doesn't save. I want to also convert
this form to a report-will the addition of new info data entered into the
form carry over into the report automatically when I get the above problem
resolved?

The control Source of your combo box must be set to a field in a
table/query if you wish to save the data.
Otherwise how would Access know where to save the data?

Newly entered data into a form is not saved until...
you close the form.....
you navigate to another record.....
you explicitly tell the form to save the data.

For the last item, using code to open a report with the newly entered
data, you could write:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", acViewPreview