Limiting Available Values in a Form

[Lloyd]

I am struggling with a design issue that I'm sure others
can help me with.

I have created a Staff table with fields for Staff and
Position and a Grants table with a series of "tickler"
fields - NextActor, NextAction and NextActionDate. There
is a list of about twenty possible NextActions, but they
are specific to individual Positions.

When a user fills in or changes a staff member as the Next
Actor, I would like the system to clear the NextAction
field and limit choices available in the NextAction field
to those appropriate to that staff members position.

It is unclear to me where I make the link between Position
and NextAction and how I implement that link in a form.

Thanks,

Lloyd

 

[Allen Browne]

Use the AfterUpdate event procedure of NextActor.

To clear the NextAction field, just set it to Null:
Me.NextAction = Null

In the Enter event of the NextAction combo, create a SQL string that gets
just the actions for the actor, and assign it to the RowSource. Example at:
http://www.mvps.org/access/forms/frm0028.htm