Copy or move value between 2 controls

  • Thread starter Thread starter Bardia
  • Start date Start date
B

Bardia

I need to copy or move data from one control to another. Both are currency
fields on a form, one for cash amount and the other for credit card amount.
By mistake, several hundred credit card charges entered into cash control.
Please advice
 
I need to copy or move data from one control to another. Both are currency
fields on a form, one for cash amount and the other for credit card amount.
By mistake, several hundred credit card charges entered into cash control.
Please advice
Click to expand...

So you wish to move some of the Cash field values into the Credit Card
field, and then delete those Cash values from the record?

OK, how would Access (or we) know which of the records have had the
Credit Card values inappropriately applied into the Cash field?

And why do you have 2 separate fields (instead of just one) in the
first place? Do you have a field for just $1 bills, and another for $5
bills, and another for $10 bills, etc.? I don't think so.
One field for the payment would do nicely. If you wish to track which
are credit card payments and which are cash payments, another field in
the record to indicate the payment type is all you need.
 
I need to copy or move data from one control to another. Both are currency
fields on a form, one for cash amount and the other for credit card amount.
By mistake, several hundred credit card charges entered into cash control.
Please advice
Click to expand...

The data is not in the form, so the direct answer is You Can't.

A form is just a window. It stores data in a Table; the data exists in the
table, and only in the table. You can run an Update query to update the Credit
field to the value in the Cash field, and simultaneously update the Cash field
to Null (effectively moving it).

HOWEVER... you will need some sort of criteria to determine *which* records
need to be updated. Nothing in your post indicates how you could determine
*which* several hundred records need this...

I fully agree with Fred's concern that your table structure is less than
ideal.
 
Back
Top