Prev: Updating text field to new numeric field & moving minus sign to fr
Next: Week starts on Friday
From: eckert1961 on 20 May 2010 21:45
I've made some head way. Here is what I have so far.

Private Sub GradeAttempting()
If Nz(Forms.Members.Ready, True) = True And Nz(Forms.Members.Active, True) =
True Then
With Forms.Members.GradeAttempting
.SetFocus
.ListIndex = .ListIndex + 1
End With
End If
End Sub

This works but only for the member that I have the form open to. To update
the rest of the records I have to manually navigate through all members and
run the code for each page.

What I want is have the code cycle through all of the records and update
GradeAttempting. What code do I need to accomplish this?
--
Regards,
Chris


"eckert1961" wrote:

> Hello,
>
> I need some additional guidance to get this to work. Where would I place
> this code? Do I create a module and assign it to a command button? Here is
> some additional information.
>
> Combobox Name: GradeAttempting
>
> Forms Name: Members
>
> Checkbox Name: Ready
>
> Any additional assistance would be greatly appreciated.
> --
> Regards,
> Chris
>
>
> "eckert1961" wrote:
>
> > Thanks Pieter,
> >
> > What code would I add to this so that all records would be checked to
> > determine if that Ready checkbox is selected? I also forgot to mention that
> > along with selecting the next item in the cbo I also want to clear the Ready
> > Flag.
> > --
> > Regards,
> > Chris
> >
> >
> > "PieterLinden via AccessMonster.com" wrote:
> >
> > > eckert1961 wrote:
> > > >Here's some additional information. On the form that the combobox is on I
> > > >also have a checkbox labelled Ready. On the update if the checkbox is
> > > >selected then I want the combobox to select the next item on the list.
> > > >> Hello,
> > > >>
> > > >> I have a combobox on a form and currently I manually select the next item
> > > >> for a member as needed. This is fine for 1 or 2 but typically I have to do
> > > >> this for 20+. Is there a way to select the next item on the list either using
> > > >> an update query or code?
> > >
> > > If <condition> Then
> > > With Me.cboDates
> > > .SetFocus
> > > .ListIndex = .ListIndex + 1
> > > End With
> > > End If
> > >
> > > --
> > > Message posted via AccessMonster.com
> > > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201005/1
> > >
> > > .
> > >
First  |  Prev  | 
Pages: 1 2
Prev: Updating text field to new numeric field & moving minus sign to fr
Next: Week starts on Friday