Combo Box Requery Issue

[Grizz2]

I have two combo boxes (PACTypeID and PACCodeID). PACCode ID is dependent on the selection made in PACTypeID. The default view for this form is datasheet so that I can see all entries. The problem is once I enter my first record and go to enter the second record, I can no longer see the first record.

Background info:
Event procedure on PACTypeID:
cmbPAC_type_AfterUpdate ()
cmbPacCode.Requery

There are 3 PACTypes: Payment, Credit and Debit. Dropdown list for PACCodeID is determined by PACType selected.

Example:
If I select PACType "Payment", I get a list of Payment PACCodeIDs to choose from. I make my selection. Then I add a new record and select PACType "Credit" this time. I get a list of Credit PACCodeIDs to choose from, but the Payment PACCodeID I selected on the prior record is no longer visible (although it it stored).

I want my datasheet to look like this:
PACType PACCodeID
Payment Patient Payment
Credit Insurance Adjustment


Payment Insurance Payment
Debit Bad Debt Recovery

Right now, it looks like this:
PACType PACCodeID
Payment
Credit
Payment
Debit Bad Debt Recovery

How can I get the entries to remain visible?

[orange]

Watch this free video tutorial on cascading combos and see if it helps.
http://www.datapigtechnologies.com/f...combobox2.html

[Grizz2]

Awesome tutorial. Certainly helpful. It confirms that I have used requery correctly. My issue still exists. The difference between the example provided in the tutorial and my form is that my form is a datasheet view so there are multiple records show on one sheet. When I enter the next record, the selection in the first record disappears from view. What am I missing?

[orange]

Try this one. I haven't used it or studied it, but I am familiar with the author
AD Tejpal.

http://www.rogersaccesslibrary.com/f...l?KW=combo#576

[Grizz2]

This looks like it might be the answer! I will let you know in a few days after I have a chance to sit down with this again. Thanks!