Lookup value based on a value in another field on the same form

[fipp]

I know that subject line is probably confusing. I will try my best to explain.

I have a form called 'playentry' and it contains data in a football game.
there is a field called [playtype]. This field identifies the play as one of
3 values. An "offensive play", "Defensive Play", or "Special Teams Play".
I have another field called [playcall] this is a combo box with the results
based off of a query of the table 'playcall'
The table playcall has 2 fields in it one called "play" which is a
discription of the play that is called and the other "playtype" being the
type of play ("Offensive Play", "Defensive Play", "Special Teams Play"
What I would like to do is when I open the combo box playcall on my form I
would like it to filter the records where the field playtype is equal to the
value of playtype on my form. This would eliminate me seeing all the values
for offensive and defensive plays when I am entering a value for a special
teams play and so on and so forth.

I hope that makes sense. Thanks for your help.

 

[Piet Linden]

I know that subject line is probably confusing. I will try my best to explain.

I have a form called 'playentry' and it contains data in a football game.
there is a field called [playtype]. This field identifies the play as oneof
3 values. An "offensive play", "Defensive Play", or "Special Teams Play".
I have another field called [playcall] this is a combo box with the results
based off of a query of the table 'playcall'
The table playcall has 2 fields in it one called "play" which is a
discription of the play that is called and the other "playtype" being the
type of play ("Offensive Play", "Defensive Play", "Special Teams Play"
What I would like to do is when I open the combo box playcall on my form I
would like it to filter the records where the field playtype is equal to the
value of playtype on my form. This would eliminate me seeing all the values
for offensive and defensive plays when I am entering a value for a special
teams play and so on and so forth.

I hope that makes sense. Thanks for your help.

Like this:
http://www.mvps.org/access/forms/frm0028.htm