CYCLING THROUGH A COMBO_BOX via code and updating subform

I have a form that updates, via an unbound cbo, a subform that shows a
member's acct. balance. (the cbo is the member list). I want to automate an
end-of-month "fund transfer" by cycling through the cbo one member at a
time, check balance and run code based on the value finishing with updating
the subform balance. I then want to cycle the cbo to the next member and
repeat until EOF. The cbo should update the subform of course. I'm pretty
confident I can do the "internal logic" but haven't been successful getting
the cbo to cycle.

Thanks in advance for any and all replies!
--
Ray Tweedale
All-around-nice-guy

ADDITION TO FIRST POST !!
I want to do this via a cmd control. one-click and voila, all fund transfers
made, recorded and documented

You can do it on a Recordset based on the same SQL as your
combo box.

HTH
Kevin Sprinkel

-----Original Message-----
I have a form that updates, via an unbound cbo, a subform
that shows a
member's acct. balance. (the cbo is the member list). I
want to automate an
end-of-month "fund transfer" by cycling through the cbo
one member at a
time, check balance and run code based on the value
finishing with updating
the subform balance. I then want to cycle the cbo to the
next member and
repeat until EOF. The cbo should update the subform of
course. I'm pretty
confident I can do the "internal logic" but haven't been
successful getting
the cbo to cycle.

Thanks in advance for any and all replies!
--
Ray Tweedale
All-around-nice-guy
.

Kevin,

I need actual code. I've tried some Bookmarking examples I found but was
unable to get them to work. I don't have access to that sample right now but
I recall it cloning the rs and using bookmark.

I've know VB well (not VBA though) and know basic Access.



"Kevin Sprinkel" wrote:

You can do it on a Recordset based on the same SQL as your
combo box.

HTH
Kevin Sprinkel

-----Original Message-----
I have a form that updates, via an unbound cbo, a subform
that shows a
member's acct. balance. (the cbo is the member list). I
want to automate an
end-of-month "fund transfer" by cycling through the cbo
one member at a
time, check balance and run code based on the value
finishing with updating
the subform balance. I then want to cycle the cbo to the
next member and
repeat until EOF. The cbo should update the subform of
course. I'm pretty
confident I can do the "internal logic" but haven't been
successful getting
the cbo to cycle.

Thanks in advance for any and all replies!
--
Ray Tweedale
All-around-nice-guy
.

Ray,

I'm afraid I can't help you further; I've never had the
need to step through a recordset, although any good Access
Reference book should be able to help you.

See VBA Help (Ctrl-G, Help from the Database Window) on
the RecordsetClone property and its related links. I
believe it makes a copy of the recordset underlying the
current form, which I don't believe what you want to do--
you want to use a recordset duplicating the query
underlying the combo box.

Sorry I couldn't help.
Kevin Sprinkel

-----Original Message-----
Kevin,

I need actual code. I've tried some Bookmarking examples
I found but was
unable to get them to work. I don't have access to that
sample right now but
I recall it cloning the rs and using bookmark.

I've know VB well (not VBA though) and know basic
Access.



"Kevin Sprinkel" wrote:

You can do it on a Recordset based on the same SQL as
your
combo box.

HTH
Kevin Sprinkel

-----Original Message-----
I have a form that updates, via an unbound cbo, a
subform
that shows a
member's acct. balance. (the cbo is the member list).
I
want to automate an
end-of-month "fund transfer" by cycling through the
cbo
one member at a
time, check balance and run code based on the value
finishing with updating
the subform balance. I then want to cycle the cbo to
the
next member and
repeat until EOF. The cbo should update the subform
of
course. I'm pretty
confident I can do the "internal logic" but haven't
been
successful getting
the cbo to cycle.

Thanks in advance for any and all replies!
--
Ray Tweedale
All-around-nice-guy
.


.