By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Displaying 1 ID's record from query in a form from combo-box

P: 2
I am new to Access (trying to read things online and create database as I go). I have been creating an inventory database. The database contains hundreds of wells with their equipment. Right now I am focused on the tanks. Each well may have an oil or water tank. For these tanks the sizes can vary.

I had a crosstab query showing the count of each type of tank (counted volumes of oil tanks in one row and water in another). Now, I need to have a form that displays the query results for just ONE well using a combo-box or something similar. I cannot figure out how to do this when the query is a subform on my form. Thank you for any help.
Dec 21 '11 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,494
Have a play with Example Filtering on a Form. You may find it helps you to understand what you actually want.
Dec 21 '11 #2

P: 2
I played around with the example some. As I said I am brand new to Access last week so just having to learn by trial and error. I see the filters work with a table, would they work with a query somehow in a form? Also, what if instead of panning through all the results of account type 2 you wished to see them in a table below? Thank you for your assistance.
Dec 21 '11 #3

Expert Mod 15k+
P: 31,494
Filtering works on the record source whatever that may be, so yes. It works with queries too.

If you want to see all the results displayed as continuous data instead of only one record at a time then you would need to set the View of the form (A property) to Continuous Forms.
Dec 22 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.