Interrelated Bound Combo Box problem

[RichD]

I have two combo boxes on a form, cboFund and cboCostCentre.

Both combos are bound to fields on the form; Fund and CCentre
The selection in cboCostCentre is dependant on the fund selected in cboFund. cboCostCentre is requeried on the cboFund After Update event.

The ID's of each selection are copied successfully to the underlying table.

The problem I have is that when you move from one record to another the CostCentre description (COL1, COL0 is 0cm) does not appear.

I have checked FAQ 9b and it does not address this problem.

TIA

Rich Lead Developer

http://www.blsoftware.co.uk

 

[930driver]

Requery cboCostCentre in the OnCurrent event of your form. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[RichD]

930driver,

Many thanks, such a simple solution. I can now stop banging my head against that wall.

Rich Lead Developer

http://www.blsoftware.co.uk