use one control to affect another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dolphin_Hwii - 14 May 2005 01:09 GMT

I have a sub form that deals with registering people for events. These
sessions are offered 16 times a year with 7-9 different activities each
session.

In my regestration form I have a date field and I would like to be able to
use that to filter data in the event field so that I only have to choose from
7-9 fields instead of 150+. I also need to be able to go to the next record
and be able to chose from a new set of dates.

Is this possible????

Please Help as I am a newbie and a volunteer myself.

Thanks for your time.

Reply to this Message

Duane Hookom - 14 May 2005 04:18 GMT

I'm not sure what you are expecting? You mention "choose from 7-9 fields
instead of 150+". Do you really mean fields? Or, do you mean values from
different records? Are you attempting to limit a combo box row source based
on the value selected in another combo box?

Signature

Duane Hookom
MS Access MVP

>I have a sub form that deals with registering people for events. These
> sessions are offered 16 times a year with 7-9 different activities each
[quoted text clipped - 12 lines]
>
> Thanks for your time.

Reply to this Message