Auto populate form field from previous value in field

Auto populate form field from previous value in field

Post by Qm9lcnNldW » Mon, 26 Jun 2006 04:11:01


I capture sales data in a form with a sub form.

The main form is bound to a table "invoice_no" with a field "invoice_number".

The sub form is bound to a table "sales" with the fields "invoice_number",
"invoice_date", "sold_date", "qty_sold" and "price_sold".

I want to populate the next record in the "sold_date" field with the
prevoious value in the "sold_date" field.

Suggestions please?

--ccs5201
 
 
 

Auto populate form field from previous value in field

Post by » Mon, 26 Jun 2006 06:21:35

have you tried sold_date.oldvalue




"invoice_number".

 
 
 

Auto populate form field from previous value in field

Post by eos » Wed, 28 Jun 2006 22:51:55

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George
 
 
 

Auto populate form field from previous value in field

Post by eos » Wed, 28 Jun 2006 22:51:55

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George