Combo Box Control Source

[Beanie_d83]

Hi there,



a simple question for all you experienced Access users but why won't a combo box on a form populate a field in a table? Am I right in thinking it has something to with its control source?

I want it to look up from a field list in one table (Row Source tbl_dealer) and then place it in a field named Customer in tbl_BuildSheet.

Can anyone help a novice out of his depth?

[ranman256]

control source is the table field the combo fills
row source is all the choices that fill the combo list.

[Beanie_d83]

This is what I thought but had my doubts when I tried to select the combo box control source, the table and or table field I need it to populate does not show in the drop down list.

[Beanie_d83]

I have the combo box listing the field data I want but the control source I just can't figure out.

What do i need to do to get the CB to put the selected record field into another table field as all I can get is a warning in the bottom left that reads control can't be edited, it's bound to expression [tbl_BuildSheet]![Dealer] which is where I want it to go!!

[Beanie_d83]

Ok so perhaps it wasn't a simple question after all

[orange]

I suggest you tell us in simple terms, what you are trying to do. No jargon-just plain English.
If you can describe an example that may help also.

[John_G]

...then place it in a field named Customer in tbl_BuildSheet.

If tbl_Buildsheet is not the recordsource for the form, then you cannot do this directly - you would have to use VBA to add/update a record.

If tbl_Buildsheet is the recordsource, then the field you want to update (Customer or Dealer? You have used both) should be shown in the dropdown list of fields in the Control Source property of the combo box.

What type of field are you wanting to populate in tbl_Buildsheet? If it is anything other than a simple text or numeric, then that may be causing your problem. In particular, if it is a lookup field, then I'd be almost sure it's that.

[Beanie_d83]

If record source is the same as row source then no, I am wanting the combo box to get the values from a field in tbl_dealer and place it into tbl_BuildSheet.

I've checked the data type for the field I want to populate and it is the (short) text type and I have made sure not to use lookups on a table level.