Clive,
I have looked at your proposal. I would like to have a combo box on the previous form where the user enters the time and date and other information for the event.
The flow of the forms would be so much better if I could get this combo box to work.
The problem is that the previous form is a continuous form and when I put a unbound combo box on a continuous form it changes for all the records when I change it for one record. Any way around that? There is no field in the underlying query or table that could hold this grade level data. I suppose I could add a field to the table just to hold the data for the grade combo box but that just does not seem like the right answer.
From my reading I have not found a good way to do this.
Thanks for your help.
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, "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.
Tidak ada komentar:
Posting Komentar