field related to combobox

[lico]

hi everyone,

access amateur,
i've created a form with a combo box and i want other fields in the
form to be related to the option chosen in the combo box, for example,
if a user want to enter data on a new computer part through a form
the first step will be choosing the type of hardware in the combobox list, for example CPU,
once the hardware type is chose the form will desplay fields related only to CPU,
if the user choose some other part the fields in the form will change according
to the hardware item chose by the user.

all the data is stored in one table.
can i do it through access or is VBA involved?

thanks.

 

[ajetrumpet]

http://support.microsoft.com/kb/319482/en-us

If you want this process to be a trade-off among multiple combo boxes that can be chosen from, more VBA will be required (a lot more, depending on how complicated you want to make this (the more complicated it gets for you, the easier it gets for the user, USUALLY!)) than what you see in that article.