Query "Show box"

[wingforward]

I have a query as the basis for a form. I'd like to include another query in that query in order to narrow down the found set of records. I don't need any data from the subquery on the form. The recordset is now not updateable which doesn't work for me.

The recommendation I've seen is to uncheck the "Show box" in the subquery. But I'm not even showing any records from that query, just the table. There is no show box to uncheck.


Thanks
DJ

 

[jdraw]

I have a query as the basis for a form. I'd like to include another query in that query in order to narrow down the found set of records. I don't need any data from the subquery on the form. The recordset is now not updateable which doesn't work for me.

The recommendation I've seen is to uncheck the "Show box" in the subquery. But I'm not even showing any records from that query, just the table. There is no show box to uncheck.


Thanks
DJ

Are you saying you want to add conditions in the where clause of the query?

Here's a link to some forms to create filters that may be helpful.
http://www.fontstuff.com/access/acctut17.htm

 

[wingforward]

Are you saying you want to add conditions in the where clause of the query?

I don't know.

I have a table of Memberships and a form to show the Membership data. I have some unbound text boxes that I want to use to filter the records shown: by Company name, Contact Name, Renewal date.

I've set an AfterChange event on those text boxes to Requery the form.

To make updating the filter easier I'd like to put all the logic of the filters into one query and then join it to the underlying table matching the PK of Memberships in the table with the same PK in the query.

Here's a link to some forms to create filters that may be helpful.
http://www.fontstuff.com/access/acctut17.htm

I think I'm doing something similar, though I'm using the query builder rather than VBA to build the SQL. I'd classify myself as a beginner (but not novice) with Access and VBA and SQL.