467,087 Members | 1,225 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,087 developers. It's quick & easy.

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

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
  • viewed: 1061
3 Replies
Expert Mod 16PB
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
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 16PB
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.

Similar topics

3 posts views Thread by Mike Cocker | last post: by
3 posts views Thread by Harvey | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.