data access pages

[daveonion]

hi all,
The problem - I am creating a data access page for the intranet. I have got a combo box of regions and i need, once the desired region has been selected, for another combo box to show departments exclusive to each region, eg
region one has an it department and sales where as region two has contracts and marketing. so when somebody selects region two they will only be able to see the contracts and marketing department in the combo.
in access i know you just refer to the field name in the query but what is the method in access pages.
help and solutions would be greatly appreciated.
thanks
dave

 

[daveonion]

somone help

 

[Paulsly]

Hi there I suggest the best way to do this.
Is buy using Group filter Control
Read up about it on the access help menu or assistant It explains to you how to set it up and The explanation is very basic to understand.
Hope this helps you
Cheers Paul