List box question

  • Thread starter Thread starter Alex Anderson
  • Start date Start date
A

Alex Anderson

Hello everyone,

I'm not sure what is involved but, on my form I have a combo box that
has a list of values (generated by a table query from a table) along with
another combo box that I want to list only it's sub-attributes. For
example, on the first list box, I select Operating system, when I go to the
next list box, I want only the sub-attributes associated to it's parent
attribute.

I would like also, if the value is not listed in the combo box/list I
want to be able to add the value on the fly rather adding it to the table
where the list resides. Are both these options feasible? What programming
(if any) is involved? If someone could give me some ideas or suggestions I
would highly appreciated.

Thank you
Alex Anderson
 
Hello everyone,

I'm not sure what is involved but, on my form I have a combo box that
has a list of values (generated by a table query from a table) along with
another combo box that I want to list only it's sub-attributes. For
example, on the first list box, I select Operating system, when I go to the
next list box, I want only the sub-attributes associated to it's parent
attribute.

I would like also, if the value is not listed in the combo box/list I
want to be able to add the value on the fly rather adding it to the table
where the list resides. Are both these options feasible? What programming
(if any) is involved? If someone could give me some ideas or suggestions I
would highly appreciated.

Thank you
Alex Anderson
Click to expand...

These 2 urls should answer both questions.

http://www.mvps.org/access/forms/index.html
http://www.mvps.org/access/forms/frm0015.htm
 
Fredg,

Thank you for the help. I do have one question. How would I set up the
table structure following the code presented by Limit Content of combo/list
boxes? Here's the link: http://www.mvps.org/access/forms/frm0028.htm

Also, I do believe this what I'm trying to accomplish, I just don't have
the understanding how to construct the tables then apply the code.

Thank you
Alex Anderson
 
Back
Top