Matching Company name indicator

[Guest]

I have a marketing database used for cold calling companies, I currently have
a form based on a state look up query. I want the form to display an
indicator of some type when there is a record with an identical company name
field in the query (same state) as the selected record.

Ideally I would like a subform which would list the pk of all records with
the matching company name. i have searched the forum and found simular post
and will try to work off some of those, but none I see display matching
records in a sub-form.

Thanks for any help.

Barry

 

[Guest]

Not really sure about this - IF should help. But what the hell you're not
even in the same country so not likely to call ?????

Quite simple to creat 2 queries ensure the join property is set to show all
record (for the state) and only .... etc. Use this to create your form.

Or