Inserting record in a table via loop

[Jack]

I have the following problem:

I have an Access form named frmClient. This form holds details of Payment
and Credit information for a particular client. In this form there are two
combo boxes named cboPaymentchk and cboCreditchk. Due to certain conditions a
particular client may have contents of forecolor of each of the combo box
turn red.


Now I need to come up with a procedure that will extract information of each
of the client and insert the information in a new table.

Thus:

If ((Forms!frmClient.cboPaymentchk.Forecolor = vbred) or
(Forms!frmClient.cboCreditchk.Forecolor = vbred)) Then
--Procedure
--insert into a field named Approved of a table named approval 'No' with
ClientiD field as the current client id.
This needs to be in a loop to extract all the clients.
End If
I can handle this for a particular client. What I am not sure about is how
to you extract all client with the above information and insert the value to
the new table.

Any help is appreciated. Thanks in advance.