Combo boxes/subforms (Access 2002)

I have an end user having a problem with a combo box on a subform. There are 2 different subforms on a form. On one subform, there is a combo box that uses a Query for the list of values, which works fine .... the list of values displays. However, you cannot "select" one of these values & update the table/field. I checked the "control source" & "record source" properties & they look fine. The column that is bound is okay as well. I can't seem to find the problem. Does anyone have any idea what the problem is?

I should also mention that the data being displayed in the combo box is coming from a different field & table than the field that is being updated ... can that be done?

Re: Combo boxes/subforms (Access 2002)

Hi Kim,

First, check the Locked property of the Combo Box (in the Data tab of the Properties window). If it has accidentally been set to Yes, the user can open the dropdown list, but not select an item from it.

If that is not the cause of the problem, test if you can changeany value in the subform. If not, there are several possible causes:
- The subform as a control on the main form is locked.
- The subform has its Allow Edits property set to No.
- The subform has its Recordset Type property set to Snapshot.
- The Record Source of the subform is not updatable.

Re: Combo boxes/subforms (Access 2002)

Okay, I checked everything you said to check and nothing is locked, etc., everything looks fine. So here's a little more information that I'm not sure if it's correct or not:

- Record source on the "Ports Subform" -- Ports (table)
- Control Source of the combo box on the subform -- VLAN (field on the Ports table that is being updated)
- Row Source Type of the combo box -- Table/Query
- Row Source -- qryVlansAtLocation

Re: Combo boxes/subforms (Access 2002)

Okay, here is the stripped down version of the database. There are 3 forms that "interrelate", so I left them in. The problem is in the "Ports" subform, the VLAN combo box. I changed the data that's in it, not sure if it's confidential or not.

Re: Combo boxes/subforms (Access 2002)

There were two problems:
1) The bound column property of the combo box had been set to 5. This is higher than the number of columns. It should be 1.

2) The VLAN field in Ports is related to the VLANKey field in tblVLANs, not to the VLAN Number field.
To solve this:
- Add the VLANKey field as first field in qryVlansAtLocation.
- Set the Column Count of the combo box to 2.
- Set the Column Widths property to 0";1".