Disappearing/Changing Combo Box Selections

  • Thread starter Rklein via AccessMonster.com
  • Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repopulating form with combo boxes in subform 1
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
list or combo box 0
Combo box 0
Using combo box when adding records to continuous form 1
Combo box text clearance problem 8
Combo Box lookup stops working. 1

Top