Manually changing attribute

[michaeljohnh]

When adding a combo box to a form with the wizard active, there is a setting that says "Store that value in this field" and you can choose a field from the source table. Is there any way to manually go in and change what field it stores in? You're probably asking why not just make a new combo box? Simple. I added new fields to the table I want to choose a field from. The new fields do not show up in the list. I tried closing out of everything, exiting Access and yet they still not appear. So I need to manually change the target field for the combo box to store its data in.



Thank you.

[jpkeller55]

Are you running the combo box off a query? If so, make sure the query you built contains the additional fields.

[weekend00]

Is there any way to manually go in and change what field it stores in?

property of the combo box: control source is the field.

[jpkeller55]

Actually, I meant to say are you running your form from a query. Make sure the query has the additional table fields otherwise you won't be able to see them in the form design.

[michaeljohnh]

Actually, I meant to say are you running your form from a query. Make sure the query has the additional table fields otherwise you won't be able to see them in the form design.

The record source is a table. I just doubled checked to make sure.