Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

filter a form with a query

1 view
Skip to first unread message

alex

unread,
Oct 15, 2008, 8:42:10 AM10/15/08
to
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

Lance

unread,
Oct 16, 2008, 3:34:01 PM10/16/08
to
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.
0 new messages