Copy data off one form to another

[Kunal Jariwala]

Can anyone help me build an expression which can copy a calculated amount
generated in one form to another... The form where the amount is generated
needs to match the 'JobID' in the original form...!!!

 

[John W. Vinson]

Can anyone help me build an expression which can copy a calculated amount
generated in one form to another... The form where the amount is generated
needs to match the 'JobID' in the original form...!!!

Don't!

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.

 

[KARL DEWEY]

Use an event to SetValue.

 

[Kunal Jariwala]

Thanks John,

but than I think I need to knw hw should I integrate "Expand" button (which)
can replace that other form and solve the problem of copying the data one to
another.

I tried integrating tat Expand button but I was unsuccessfull... see if u
can help...

 

[John W. Vinson]

Thanks John,

but than I think I need to knw hw should I integrate "Expand" button (which)
can replace that other form and solve the problem of copying the data one to
another.

I tried integrating tat Expand button but I was unsuccessfull... see if u
can help...

I'm sorry, but you're assuming that I have more knowledge of your database
than I do. What is the "expand" button? What does it do? What code does it
execute? What are you trying to "integrate"?

 

[Kunal Jariwala]

Because I didnt knew the right word I wrote it "Expand" Button... I am
talking about "TreeView Function"...

I have got Textbox where a calculated amount needs to be filled... to
calculate this amount there are three inputs required... I need these 3
inputs 'Expand' & 'Collapse' when required (beside the Textbox)... These
three inputs will be captured by the database.

I recon using tree view will erredicate my first idea of copying a
calculated amount from one form to another.

If you still unclear please do ask again... I will attach Screen Shots...

Thanks for your help.

Kunal.

 

[Kunal Jariwala]

Hello Karl,

Could you please refer to this Post again and reply with all new details
please...

Thanks.

Kunal.