CYCLING THROUGH A COMBO_BOX via code and updating subform

[Guest]

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!

 

[Guest]

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

 

[Kevin Sprinkel]

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

HTH
Kevin Sprinkel

 

[Kevin Sprinkel]

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