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

Creating a conditional drop down?

P: 1

I'm a student tech at my college's campus library and i'm in charge of inventory for our A/V equipment this summer. I've decided to use access to tackle this task, and so far things are going alright, but the forms are getting a little long-winded. I want to make use of a drop-down menu with limitations, but It's been a few years since i've used access, and i'm having a terrible time finding any helpful information online because i'm not even sure i'm wording it right. Here's my issue:

I'm currently using one form to track several different types of equipment, from computers to cameras and more, and each specific category of equipment has it's own set of information that needs to be recorded. However, I couldn't figure out a way to seperate it, so every single field of information is showing up in the form. I'm having to fill in several fields as n/a for certain peices of equipment because there's too many extra fields sitting around. I have to have them there to accomodate the needs of each specific item, but it's getting a little annoying to have so many extra fields for certain peices of equipment that only need a few.

I'd like to keep everything together in one database so that I don't have to hop around to a different database each time i'm checking our inventory. Is there any way to just create a conditional drop down field that I could choose the type of equipment from, and in doing so, limit which information fields are pulled up to fill in? I.e., if I select "Laptop Computer" in the drop-down for instance, it would pull up fields for service tag and such, but leave out other fields like barcode or model number that are irrelevant for a Laptop (as defined by me in some manner)?

I appreciate any input...

May 14 '07 #1
Share this Question
Share on Google+
2 Replies

P: 97
I have tried to create similar things in the past, with limited success.
From my experience I can suggest creating a Case-Select block that will selectively hide (Control.Visible=false) the irrelevant fields in the AfterUpdate event of your drop down box.
May 15 '07 #2

P: 3
Hey there... not sure if I understood you correctly - but I had a similar problem the other day.
I went to the tutorials section and looked up how to create cascading Combo/List Boxes. It worked perfectly for me with some tweaking - perhaps this is something similar to what you're looking for?

basically I had a number of combo boxes - after selecting the first one it populated the second - which then populated the third etc

Take a look - it's brilliantly written and I found it easy to follow - and I'm a complete Access novice.
May 15 '07 #3

Post your reply

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