Question comboboxes and lookup options

[Kijindoragon]

Hi, I want to preface this with the fact that I am really new to Access (using 2007 version). I'm working on a spreadsheet for our equipment for an ambulance department. It has things like cardiac monitors, stretchers, etc. all of which have model numbers and serial numbers.

I'm trying to figure out how to get the table to show, when I choose the item's serial number, the model number as well. Additionally I would like to have it so that when I choose an item, say stretchers, that it only offers me the relevant serial numbers as choices so I don't have to wade through hundreds of serials.

I have looked at a number of forum entries and have had no luck figuring out just what I need to do. I tried creating a form and using comboboxes but I don't understand how they work...

I tried to follow similar instructions from other threads but I feel like they explain stuff with steps missing. More likely I'm just totally clueless.

Any suggestions or direction to relevant threads is greatly appreciated.

 

[spikepl]

Learning a foreign language by peeking into a discussion forum is not an efficient way for learning it.

Do a tutorial on the web, on Access tables, queries and forms. Then you can download a free Access-template from Microsoft, and see what makes it tick.

 

[Lightwave]

As per spike but the database in this post may help - it has several combo box examples

http://www.access-programmers.co.uk/forums/showpost.php?p=1129787&postcount=29

 

[Kijindoragon]

Thanks guys, those definitely helped. I also need to figure out how to track resources over time. For instance stretcher number 12 was on ambulance 4 from may 1 to may 4 and went out for repair from may 5-14 and wound up back on ambulance 6 when it came back on the 15th. This is well beyond my knowledge