Blanks with 2 Combo Boxes Linked On A Contiuous Form
Posted on 2011-03-20
I have a continuous subform that contains two combo boxes (cb) per record. The first (cb) refers to an AcctID and the second (cb) to a SubAcctID, each bound by an ID, but displaying a description. When the User selects an AcctID with the first (cb), the second will be filtered with only the SubAcctID's that have the selected AcctID. That part works fine. I am using the query criteria "[Forms]![frmMain]![frmSub].[Form]![AcctID]" to filter the SubAcctID (cb).
The problem I am having is when a User goes to a new record the SubAcctID (cb) on the prior records goes blank if a different AcctID is selected, but not if the same AcctID is selected. The ID's are still attached to the record, but the (cb) is displaying a blank. I tried a requery,
Private Sub AcctID_AfterUpdate()
but it did not help. Any ideas where I am going wrong?
Thank you for your time,