Hi,
I have a combox field on subform C that shows records from a query.
How do I get this combo to only show records that relate to an ID on subform B.
I have a subform for storing contracts and these are stored against a company name.
On subform C I have a field that currently shows all records in a table. I need this combo to only show the records that relate the current record on subform B?
Anyone?
Thanks
I have a combox field on subform C that shows records from a query.
How do I get this combo to only show records that relate to an ID on subform B.
I have a subform for storing contracts and these are stored against a company name.
On subform C I have a field that currently shows all records in a table. I need this combo to only show the records that relate the current record on subform B?
Anyone?
Thanks