Form on Query Ignores query criteria

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I have a query that finds all records in a db with one of the query criteria
fields containg...

like 'bla bla'

then I created a form on the query.

Problem is the form ignores the query criteria and shows me all records in
the db.

Is there a way to fix this with out having to create a filter for the query
each time?

thanks for any help.
 
That doesn't make sense. If the query only returns the desired records, and
that query is the recordsource for the form, that's all that can be
displayed on the form.
 
Are you sure the record source for the form is the query and not the table?
 
Woops! You guys were right. I had the table as the data source... not the
query.

Thanks for the prompt. That fixed it.
 

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

Back
Top