need to create a list box based on the selection of another list

G

Gover

I've done this in excel using =indirect in the list box. need to repeat in
acces.. did have a response about a week ago, but cannot trace the link
someone gave me. sorry to have to ask again, but it looked exatly what i
wanted - had a new computer at work and they lost all my stored data...
thanks
 
D

Dirk Goldgar

Gover said:
I've done this in excel using =indirect in the list box. need to repeat
in
acces.. did have a response about a week ago, but cannot trace the link
someone gave me. sorry to have to ask again, but it looked exatly what i
wanted - had a new computer at work and they lost all my stored data...
thanks
Click to expand...


This link shows two ways to do it:

http://www.mvps.org/access/forms/frm0028.htm
Forms: Limit content of combo/list boxes
 
G

Gover

In excel I used list box's and in the source I had =indirect(a1) this enabled
me to let the user select which department in the first list, then depending
on their selection the second drop down list will be different - based on
their selection. I did put a post on asking how to repeat this in Access,
but cannot find my replies. So I'm posting it again... any joy?
 
G

Gover

sorry dirk, but I have looked at your link and have no idea what the codes
mean or where to type them in... never used code in access, only used access
for standard stuff so far.
 
D

Dirk Goldgar

Gover said:
sorry dirk, but I have looked at your link and have no idea what the codes
mean or where to type them in... never used code in access, only used
access
for standard stuff so far.
Click to expand...


You;re going to have to do some coding to make this work, but not much.
What's the name of your form, what are the names of your list boxes, what
are their rowsources, and how are those rowsources related to each other?
What is the field in the first list box that should be used to limit the
contents of the other?
 
Top