reference two forms (one bound - one unbound)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I has a form (main form) that open another unbound form to perform
calculalations. My problems are:

1) How do you transfer the information from the main form to the unbound
form.

2) How do you transfer the information in the unbound form (after
calculations) back to the main form

Many thanks
 
Hi,
you can refer to any open form's control like:
Forms("MyForm").MyControl
Or
Forms!MyForm!MyControl

so you can just make a proc which will copy necessary data between forms
 
hngo said:
Hi,

I has a form (main form) that open another unbound form to perform
calculalations. My problems are:

1) How do you transfer the information from the main form to the unbound
form.

2) How do you transfer the information in the unbound form (after
calculations) back to the main form

Many thanks
Click to expand...

But why would you want to do this?? If you can do the calculation in an
unbound form, why can't you do it in the main form??

You could use an unbound text box and set the control source to a formula,
you could do the calculation in the query or you could write a custom
function (UDF).
*Much* less involved than trying to move values between forms.
 
Back
Top