Cascading Combos (again) records stay but display disappears at random

[libraccess]

I had this problem at one stage but cannot remember the fix
Attached a mock up (or is that a muck up)
The Value in the second cbo just does not want to show at random
The record is there (in the table)
If the first cbo is selected and the existing value selected the 2nd cbo value reappears as it should


(If I run reports the records all show)
Just very frustrating when the form does not show the record
Any Help Please

[June7]

It's because the comboboxes are bound to fields and the combobox RowSource is based on a lookup with alias. When the combobox RowSource filter excludes records the descriptive 'alias' value might not be available for the associated ID that is saved in the record. This is expected behavior when lookup with alias is involved.

[libraccess]

it's funny because I have a DB been running for two years with bound cbos and the problem has not surfaced on that DB. Anyway thanks and onward and upward

[June7]

Are those old combos multi-column with alias?