Dropdown list sub group

[shaz0503]

All

I have a simple database entry form that holds several drop down lists. I
need to be able to - if possible - have 'sub lists' dependent on the initial
selection. I would like to have both selections recorded in the database.

any assistance appreciated

rgds

S

 

[Wayne-I-M]

Do a search in the box above (in this forum) for casscadeing combo / lists.
There are lots of codes and method shown

Good luck

 

[John W. Vinson]

All

I have a simple database entry form that holds several drop down lists. I
need to be able to - if possible - have 'sub lists' dependent on the initial
selection. I would like to have both selections recorded in the database.

If you're using a Table with Lookup Fields (dropdown lists)... don't. Table
datasheets are of VERY limited flexibility, and lookup fields have many
problems:

http://www.mvps.org/access/lookupfields.htm

Instead use a Form based on the table, with combo boxes on the Form. As noted
elsethread it's easy to make form (but not table!) combo boxes dependent on
other combo boxes. Post back if you can't find (or have trouble implementing)
the suggestions - I'd use http://groups.google.com advanced search to search
the microsoft.public.access.* newsgroups for "dependent combo".