Conditional Combo Box

[Nadihaha]

Good Afternoon,

I am using Access 2003.
Forgive me if this has already been asked.
I am setting up an ICT database, and I have a table that contains Software
ID, Hardware ID and Disc ID as well as installation date. To highlight What
software has been installed on which PC and which disc was used.

What I am trying to do is I have a form and subform that links software ID
to Disc ID, and I am tring to create a form to enter the data into the table
described above. What I would like is based on the selection made when
choosing the Software (via a combo box and stored in a field) have a combo
box provide the appropriate selection of Disc ID's (to be stored in a field).

How do I do this?

Many Thanks

 

[golfinray]

You said you have "A" table.
With one table I think you could just set up a form, not form and subform.
Form and subform are usually used for a one to many relationship. Unless you
have one hardware and many softwares and drives, what you would want to do is
possibly search on diskid for a given softwareID. The combo box will do that
for you. Use the combo wizard to set it up. Good luck!

 

[Nadihaha]

Hi Milton,

Thanks for that. However we have many lots of Hardware, and Software.

The problem I have is that we may have 5 copies of 1 Software (eg Windows)

So what I'm trying to do is say on Computer 1 we have disc 2 of Windows XP
Installed. So that then I can do a report for our IT guy for if a computer
needs a rebuild or a user gets a new PC I can print a report including which
Disc numbers are required.

I currently have a form to enter the software information and then a subform
to enter the disc numbers.

However I would like to be able to pick the Software ID from one dropdown
and then based on that selection display the Disc ID's for that software in
the next combo box.

 

[Gina Whipp]

Nadihaha,

You told us which tables you have but not how they are related to each
other. Sounds like there might be a table or two missing. If you could
provide a list of tables and they fields (PK and FK) and how they are
related we can give you a more comprehensive answer.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm