Moving data from form to form

[John V]

Let me see if I can explain...

I have a form for a user to edit a memo field using a
wysiwyg html editor. This form will be called from many
forms by clicking on an edit button. I can't use the
editor in each form because it is too big.

I have the code to send the data from a particular
textbox on a form (form1) to another form (form2) and
into the editor using a simple assignment to editor.data.
That works fine and I also assign to a hidden textbox on
form2 the textbox name from form1 that is sending the
data. This is so when I save and close form2 it can send
the data back to the original textbox.

The problem is I can't get the data back.

Any suggestions on a good way to do this. form2 will be
used to edit data from multiple forms and textboxes
within each form.

Thanks in advance,

John

 

[Jonathan Parminter]

-----Original Message-----
Let me see if I can explain...

I have a form for a user to edit a memo field using a
wysiwyg html editor. This form will be called from many
forms by clicking on an edit button. I can't use the
editor in each form because it is too big.

I have the code to send the data from a particular
textbox on a form (form1) to another form (form2) and
into the editor using a simple assignment to editor.data.
That works fine and I also assign to a hidden textbox on
form2 the textbox name from form1 that is sending the
data. This is so when I save and close form2 it can send
the data back to the original textbox.

The problem is I can't get the data back.

Any suggestions on a good way to do this. form2 will be
used to edit data from multiple forms and textboxes
within each form.

Thanks in advance,

John

Hi John, before closing the form for a successful entry
you can refer to another form and control to pass a value.
Use the following as an example:

dim ctl as access.control
set ctl=forms("form1 name").Controls([hidden textbox name])

ctl=[textbox name with data]

set ctl=nothing

Luck
Jonathan