Independent Transfer!!!

[kennykee]

I got two form (Form A and Form B) based on two tables/queries respectively.
Both Form A and Form B have exactly same field name. Both Forms are Invoices.

EG
In Form A (single form view)
I got a checkbox, if

checkbox = true
All the records in the current subform of a form A will be copied and paste
to Form B 's subform of a new Form B automatically once checkbox is checked

On the other hand, if the checked checkbox unchecked, the copied records
will be deleted

In short,
FormA checked==>copy and paste ==> New FormB
FormA unchecked ==>delete copied records ==> delete FormB page

The data from FormA is added to new record of FormB.

Any solutions?

Inform me if you need for informations.

Thanks in advance.

Kennykee

 

[Lance McGonigal]

Well this is a mouthful but what I think you said is based on the status of
a checkbox you want one of two actions to occur. If this is the case then
I'd suggest that you put a little code behind a button on the form that when
clicked checks the box. Based on the value of the box a set of actions
occur.

Sample:

My_Button_onclick()

if mycheckbox = true then
do this...
else
do this...
end if

exit function

Good luck

 

[kennykee]

Thanks Lance,
but the actually things I required is the code that you posted with the
words "do this..."

Any solutions?

Thanks in advance.

Kennykee