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

[harp_s45]

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

 

[Ken Snell [MVP]]

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