Access 2003: Select Next Item in Combobox

  • Thread starter Thread starter eckert1961
  • Start date Start date
E

eckert1961

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?
 
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.
 
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.
 
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.
 
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?
 
Back
Top