Hi,
Please correct me if I'm wrong.
I have a Combo Box with RowSourceType=fields and
RowSource=TableName.FieldName
The Table is the child in a relation so that only a subset of records are
accessible at any time.
Yet the Combo Box doesn't seem to respect the relation even after a
Requery.
Is that the way it works? I had assumed that the Combo Box would only
display the rows that are currently available based on the relation.
Thanks for your help,
Frank