Query on Form Data

[darryaz]

I am designing a query based on the data displayed on a form. I want the query to return the related records but EXCLUDE the record displayed on the form.

I'm very close. I get the data I want PLUS the current record.

Is there a command to EXCLUDE the current record?

 

[Alansidman]

In the criteria of the query, in the field that has the unique identifier for the record put <>forms![your form name].[your field name holding the unique identifer]

 

[darryaz]

Thanks, I figured it out on my own right after I posted. That's exactly what I did and it worked great!!