R
Rklein via AccessMonster.com
First post, so be gentle. Here goes...
In Access 2003, I have a subform (headerdeductcodes), with the recordsource
being a table, connected to the main form by a ParentID. Within the subform,
I have two combo boxes: Deduction_Type (SELECT DeductTypes.TABLE_ID,
DeductTypes.SYSCODES_FIELD1 FROM DeductTypes) [a table],
and Deduction_Description, which is populated based on the option selected
from Deduction_Type.
The After Update code for Deduction_Type reads:
Private Sub Deduction_Type_AfterUpdate()
Me.Deduction_Description = Null
Me.Deduction_Description.RowSource = "SELECT DeductDescTable.TblID,
DeductDescTable.DeductDesc, DeductDescTable.DescripID, DeductDescTable.Rate
FROM DeductDescTable WHERE (((DeductDescTable.TblID)=[forms]![form1]!
[HeaderDeductCodes]![tableid]));"
Me.Deduction_Description.Value = 0
End Sub
The problem arises when the subform loses focus, some of the selected options
from Deduction_Description either disappear or change values. The actual
values written to the table don’t change, but, to the user, the selected
values are no longer visible or changed. Any ideas on how to keep the
Deduction_Description selected options on the form after focus is lost?
In Access 2003, I have a subform (headerdeductcodes), with the recordsource
being a table, connected to the main form by a ParentID. Within the subform,
I have two combo boxes: Deduction_Type (SELECT DeductTypes.TABLE_ID,
DeductTypes.SYSCODES_FIELD1 FROM DeductTypes) [a table],
and Deduction_Description, which is populated based on the option selected
from Deduction_Type.
The After Update code for Deduction_Type reads:
Private Sub Deduction_Type_AfterUpdate()
Me.Deduction_Description = Null
Me.Deduction_Description.RowSource = "SELECT DeductDescTable.TblID,
DeductDescTable.DeductDesc, DeductDescTable.DescripID, DeductDescTable.Rate
FROM DeductDescTable WHERE (((DeductDescTable.TblID)=[forms]![form1]!
[HeaderDeductCodes]![tableid]));"
Me.Deduction_Description.Value = 0
End Sub
The problem arises when the subform loses focus, some of the selected options
from Deduction_Description either disappear or change values. The actual
values written to the table don’t change, but, to the user, the selected
values are no longer visible or changed. Any ideas on how to keep the
Deduction_Description selected options on the form after focus is lost?