filter a form with a query

A

alex

Hello everyone,

using Access '03...

I have a form based on a table and I'd like to filter the table
records (in my form) by utilizing a query.

Something like:

Me.Filter = "[Identifier] = [qryLink].[Identifier]"

I can't get the damn thing to work!

I want to show all the records in one table where a record in that
table = a record in a query.

any thoughts?
alex
 
L

Lance

Have you considered using the form filter property instead of a query?
Essentially you're querying the forms datasource directly instead of having
to pull from some other object.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top