Selection Box's ? Noob question ..... please help !

Hi Im a noob to access and this forum so I will apologise if his is a stupid
quyestion or if this has been answered else where.

I am putting together a form/data sheet to collate a questionnaire (i.e what
sports people have played)

I have the usual
name (sur and fore)
Interest e.t.c

then a field for activity :-i.e rugby , football e.t.c

I would like to link a second field to this in a form so when I select rugby
as a previous activity the next selectable field changes the options I can
select to only the rugby positions . same for football e.t.c

I hope this makes sense Im very new to access and have been mudling my way
through so far and got stuck when trying to do this !

Thanks

See this article for how to relate two combo boxes to each other:
http://www.mvps.org/access/forms/frm0028.htm


--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"harp_s45" u53010@uwe wrote in message news:988491f31b811@uwe...
Hi Im a noob to access and this forum so I will apologise if his is a
stupid
quyestion or if this has been answered else where.

I am putting together a form/data sheet to collate a questionnaire (i.e
what
sports people have played)

I have the usual
name (sur and fore)
Interest e.t.c

then a field for activity :-i.e rugby , football e.t.c

I would like to link a second field to this in a form so when I select
rugby
as a previous activity the next selectable field changes the options I can
select to only the rugby positions . same for football e.t.c

I hope this makes sense Im very new to access and have been mudling my way
through so far and got stuck when trying to do this !

Thanks