Combo Box in Subform not working

[David Ball]

Hi,

I have a Form that shows "Equipment Numbers" and a Subform with a Combo Box where "Equipment Tests" can be selected.

There is a table for Equipment Numbers, a table for Equipment Tests and an intermediate table TestsToEquipment, where Tests can be assigned to Equipment.

When I try to select "Equipment Tests" for an item of equipment all the Equipment Test records appear in the Combo Box drop-down list but when I select one I get the message "Field cannot be updated".

I have another database that I built for a similar application that appears to be set up exactly the same and works perfectly.

Any ideas on what the problem could be?

Thanks very much.

Dave B.

 

[Galaxiom]

This would happen if the record source query of the subform was not updateable.

I would expect the subform RecordSource would be the TestsToEquipment table (or a query based on that table) with EquipmentID as the Master and Child Link Fields. The RowSource of the combo would be from the EquipmentTest table, displaying the TestName and recording the TestID.

If instead you used a query with a join between TesttoEquipment and EquipmentTest to put the TestName directly in the combo then I would expect it to be non-updateable.

 

[David Ball]

That has given me enough info to solve the problem.

Thanks very much.

Dave B