Data dependent check box

[hrg]

Hi

I have a database with two forms. On one form there is a check box (form1). On the other there is a form with a list box(form2). When clicking the check box i want data on the form1 to be sent to the list box in form2. The data will be a name, address, title & postcode (this information is held in form1 in text boxes). I also have a query which tells the list box what data is displayed (it acts as a link at the present time between form1 and 2).

Does anybody know how to GET

The information from the text boxes(form1) to the list box(form2) ONLY if the check box(in form1) is TICKED.

Thank you for your time

 

[UncleJack]

Both forms must be open in order for them to see each other otherwise an error will result. On form 2 simply reference the check box on form 1 with an If-Then structure:

If Forms!Form1!CheckBox then
Me!name = Forms!Form1!Name
Me!Address = Forms!Form1!Address
etc.
End if

Uncle Jack