Clive,
I was thinking about that as well. I think I will try and incorporate this
option.
Thanks
Bill Singer
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
Sent: Wednesday, June 27, 2012 2:43 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Check the grade level
Hi Bill,
Hi Bill,
On the main form you should have a ComboBox or a ListBox
or some other arrangement for selecting the GradeLevel.
Then you should filter the SubForm should for the selected
level only. That way you get what you want.
Hope that helps.
By the way, it may be better to resubmit this problem
because it might get missed becauseit is tangled up with
Msg 99639: "Drop Down Selection in Read Only".
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Singer"
<Bill.Singer@...> wrote:
>
> This group has helped me capture some errors by checking if a field is
null
> or if a time period is already booked. I have one more check to do but I
> can't figure it out and I do not believe the function will be the same as
> the previous checks.
>
>
>
> I have a main form to schedule events (sports games)
>
> I have a continuous sub form that I use to select TEAMS that will
> participate in that event. A One to many relationship. (one event to many
> teams)
>
>
>
> Each team name selected in the sub form is also tied to a specific grade
> level in the t_Teams. (table with team names) The grade level also shows
in
> the combo box but the bound column is just an ID number.
>
>
>
> Is there a way to check to make sure I am always scheduling 5th graders to
> play 5th graders and 10th graders to play 10th graders.
>
>
>
> I am thinking I will have to search the t_Eventparticipants for team names
> associated with the EventParticipantID that is currently on the form and
> then check the t_Names to see if they have the same grade level associated
> with the team. (GraID in t_Teams)
>
>
>
> I really have no idea how to structure this or what function to use.
>
>
>
> Or I could just the previous record but I am not sure how to back up a
> record.
>
>
>
> Thanks for your help.
>
>
>
> Bill Singer
>
> MN
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar