Hi Bill,
It is normal behaviour. The Combo will show the value
for the current record in all records because it's
bound to a field.
Your suggestion to have the Combo in the Form that calls
the Players list is a good idea.
You can create a WhereCondition using the value in the Combo
for the DoCmd.OpenForm.
Hope that helps.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "agent1of6" <Bill.Singer@...> wrote:
>
> 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