Requery

[Grizz2]

I have 2 combo boxes in a form: PAC Type and PAC Description. The list of PAC descriptions is determined by the PAC Type selected.

I have an event procedure set up in the PAC Type field:
cmbPac_type_AfterUpdate()
cmbPacCode.Requery

My problem is this: Once my PAC Type and PAC Description have been selected and I want to add the next PAC Type and Description, the PAC Description for the prior record is no longer visible. It is stored but not visible. The only time it is visible is when I select the same PAC Type.



What am I missing?

[NTC]

Not sure I understand the question; but in general - I see you requerying just 1 combobox but discussing 2 comboboxes. Are you needing to requery them both? Possibly it is as simple as that.

Not sure this helps.

[Grizz2]

Here is an example which hopefully is helpful:

I select "Credit" as the first PAC Type. Then I move to the next field (PAC Description) where a drop down lists all the descriptions with a PAC Type of "Credit".

Now I want to add another PAC Type. This time I select "Payment" as my PAC Type. Then I move to the PAC Description field where a drop down lists all the descriptions with a PAC Type of "Payment". When I click on the PAC Description field to get the drop down list, the PAC Description from my first record is no longer visible (although it is stored).