Checkbox and textbox relationship

[cf]

I was hoping someone here could provide a suggestion on
how to tackle this. I have a form with about 6 check
boxes and 6 textboxes. What I am trying to do is when
someone checks any of the boxes then it fills in the first
textbox with the corresponding info from the checkbox,
then the next and so on. If someone unchecks a box then
the information from the textboxes moves up one. I am
hoping once this happens I would be able to run a query
with these items in order and then provide a report from
this information. The last part I haven't quite figured
out yet, but I was hoping someone might point me in the
right direction.
Is this possible?

Thanks a bunch

 

[Jeff L]

You could use the On Update event on the check boxes to
run some code that would populate the associated text
boxes or unpopulate them depending on the value of the
check box.

Jeff

 

[cf]

I believe I have that down now. I decided to use an IF
EleseIF statement to input the information and do a For
Loop to remove the info. However, I am still trying to
figure out if the a checkbox is unchecked and the
information is removed from the textbox, how to move the
information up from one textbox to another to make sure
they are in order amd not to leave any blank in between.