carry fields from one form to another

  • Thread starter Thread starter some Girl
  • Start date Start date
S

some Girl

I have a checkbox on my form.
When the checkbox is checked or unchecked, it opens
another form.
for this part, I've been using the
'DoCmd.OpenForm "SomeForm"' in the On Click Event.

When the New form opens, I would like to carry over
some of the fields that were entered on the current
record To help avoid having to enter it twice.

Can this be done? and how?

If it isn't a good idea or can't be done, please let me
know.

thank you.
 
-----Original Message-----
I have a checkbox on my form.
When the checkbox is checked or unchecked, it opens
another form.
for this part, I've been using the
'DoCmd.OpenForm "SomeForm"' in the On Click Event.

When the New form opens, I would like to carry over
some of the fields that were entered on the current
record To help avoid having to enter it twice.

Can this be done? and how?

If it isn't a good idea or can't be done, please let me
know.

thank you.
.
Create a macro using the set value from the other form to
Click to expand...
the other. Run the macro when checkbox is clicked.
 
The data is in the tables 'behind' the forms.

So if both forms are using data from the same table, then before you open
the second form, you should save the new data into the table from the first
form, by doing a

If Me.dirty = true then

me.dirty = false

end if

in the click event, then when you open the second form the data will be
available.

On the other hand, if the second form is pulling data from a different
table, then you shouldnt be storing the same data redundantly in that table
anyway.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top