Dependant Combobox not showing current value if record viewed

[PureRadiantJoy]

Hello,
Thank you in advance for your time and any help you can lend me on this.

I have 3 combo boxes:
cboShipToDestination
cboShipToDestinationAddresses
cboRecipientVendorContact


cboShipToDestination the following Event to update
cboShipToDestinationAddresses:

Private Sub cboShipToDestination_AfterUpdate()
cboShipToDestinationAddresses.Requery
End Sub

And cboShipToDestinationAddresses has a similar event to update
cboRecipientVendorContact:

Private Sub cboShipToDestinationAddresses_AfterUpdate()
cboRecipientVendorContact.Requery
End Sub

This works fine when I select these items on the form when choosing them for
entry. And it seems to record them on the table, the problem occurs when I
move from record to record on the form. The odd thing is that I cannot see
the active entry in the cboShipToDestinationAddresses and
cboRecipientVendorContact combo boxes if the corresponding category is not
selected.

For example: I have three categories; employee, client, other ship to
destination.
If I was on a record that had employee as a category, as I go from record to
record on the form, the only records that will show the current selections
for the cboShipToDestinationAddresses and cboRecipientVendorContact for a
given record will be those that happen to have employee selected as the
category.

In principle it is not a big deal since I may simply reselect the category
and it will show the correct entry, but that means reselecting the category
when entering a viewing a record with a category that is different than the
currently selected one. This doesn't affect reports as the data has been
written to the table correctly, but the fact that it doesn't display properly
is disconcerting.

I am simply at a loss for what to do at this point. I imagine it is related
to the update event, but I don't know how to have the cboShipToDestination
refresh each time the record appears, especially if it already has a value.


Thank you for your help.

 

[George Nicholson]

Issue your cboXyz.Requery instructions within the Form_Current event as well
as the various AfterUpdate events.
That should resolve the record-to-record problem.

You would need to do this for any combos that use the "current" value of
controls to define their Rowsource criteria.

HTH,