Combo box depend of an other one - update problem - Access
Posted on 2008-10-29
I have a continuous form that shows multiple records.
On that form, for each record, I have 2 combo box (cmbDirection, cmbTitle) where one depends of the other, base on a query.
When I select a value on "cmbDirection", the values in "cmbTitle" combo box changes.
My problem is, when I change the "cmbDirection field" for one record, all "cmbTitle" values for all other records are change at the same time and take the values associate to the "cmbDirection» I just selected. That means, other records don't have anymore the right "cmbTitle" values.
How can I correct this?
cmbDirection combobox: (2 Columns, 1 description, the other the Id)
Private Sub cmbDirection_Change()
Me.txtDirectionID = Me.txtDirection.Column(1)
cmbTitle combo box RowSource property :
SELECT qry_Title.formationTitle FROM qry_Title;
Query qry_Title :
SELECT tbl_Description.Title AS formationTitle,