Copy data off one form to another

  • Thread starter Thread starter Kunal Jariwala
  • Start date Start date
K

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...!!!
 
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...!!!
Click to expand...

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.
 
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...
 
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...
Click to expand...

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"?
 
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.
 
Hello Karl,

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

Thanks.

Kunal.
 
Back
Top