Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reference in subform help! Criteria not getting desired results.

Reference in subform help! Criteria not getting desired results.

Reference in subform help! Criteria not getting desired results.

Howdy folks,

I'm working on a form (frmUpdateGameStatistics) with a subform (Player_History subform), and I'm having some trouble with a criteria I've built within the subform. Let's see if I can explain this:

The database is for hockey statistics. The "master" form is for entering game details, such as which teams are playing, and what the final score was. The subform is for entering specific actions that a player does, such as goal, assist, etc.

In the sub-form, you first choose a team. This is a drop-down choosing the following fields:

Team_Info.Team_ID (not displayed)

(Apologies to those of you who hate the underscores. (^_^) )

However, we are not actually writing this field to the subform, so it has no control source. This control is called Team.

Once you've chosen a team, you need to choose a player from a drop-down control (called Player) that is based on a query of the following fields:

Player_Info.Player_ID (not displayed)

and the problem field:
Player_Info.Team_ID (not displayed)

The intention of the last field there is this: we only want to display players whose Team_ID is equal to the Team_ID we just selected in the Team control in the subform. So, in order to do this, I gave the last field I listed the following criteria:

Forms![frmUpdateGameStatistics]![Player_History subform].Form!Team.Column(1)

I thought this should result in only the selected team's players being visible in the Player drop-down, but no matter which team I choose in the initial drop-down, I get nothing when I try to select a player.

Any suggestions would be greatly appreciated!


Steve Battisti

RE: Reference in subform help! Criteria not getting desired results.

Hi Steve,

I think you need to do something like this

Team_ID After update event

' "Player_Info.Team_ID" = combobox ie the team member cbo


Ok what we are doing (i think) is selecting a cbo that selects the team name, so the next control is the team player and what you want is after the "team" has been selected is that the user then selects from an cbo the team member form a list of members of the previously selected team. so when the user selects the team in the team cbo, the team member cbo then has a list of the team membes for the user to select from,...?


Robert Dwyer

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close