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