I need to set a filter on a query so I can run a report from a joined query. I want to do this from a form, since I already have selected a record with the [acct nbr] I want. I just can't figure out how to do this but I thought it would be simple. I need to run a report that is filtered from the joined query so I can run a text stream to put into Outlook. I have the Outlook section done. I just need the filtered text stream.
If I can't filter the query from the combo box VBA, then filtering from the Forms![acct nbr] is fine. Or, filtering the report by [acct nbr] is fine as well.
The Combo box VBA is below.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
If you will always filter from the ComboBox as it appears you do from the code above you could create the query to filter against the control itslelf. While this limits your options it's extremely simple if this is the extent of what you need to do. The query would look something like this, (Replace Fields and table names to fit your situation....
SELECT tblCustomer.CustomerID
FROM tblCustomer
WHERE tblCustomer.CustomerID=[Fo
To include the use of your Nz() fuction the query would require only a slight alteration as follows...
SELECT tblCustomer.CustomerID
FROM tblCustomer
WHERE tblCustomer.CustomerID=Nz(
If however the field is a string you'll need to remember to encapsulate the field with Quotes or an appostrophe to tell JET (Access) that the field is a string. You'll also need to check for and replace any appostrophes within the string and double them up so Jet (Access) doesn't confuse an appsotrophe in the string to be a character indicating the strart or end of the string vs. a litteral appostrophe within the WHERE clause. For example...
SELECT tblCustomer.CustomerID
FROM tblCustomer
WHERE tblCustomer.CustomerID=' & Replace(Nz([Forms]![Form1]
Business Accounts
Answer for Membership
by: ldunscombePosted on 2008-01-31 at 05:31:11ID: 20786294
You can set the criteria row of the desired field in your query to use a value from your form.
eg
Name field in query.
criteria row of name field in query
= forms!formname.controlname
Leigh