Board index » MS Access Forms Coding

All times are UTC



 Auto populate form field from previous value in field 
Author Message
Boerseu
#1 / 2
 Auto populate form field from previous value in field

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



Thu, 11 Dec 2008 03:11:01 GMT  
JethroUK
#2 / 2
 Auto populate form field from previous value in field
have you tried sold_date.oldvalue


Quote:
> 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



Thu, 11 Dec 2008 05:21:35 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Populating Date field with previous fields Value

2. Protecting fields on a Form and Auto-populating Fields on a Form

3. Auto populate a field on a form with a set of choice values

4. Auto populating fields based on previous choice

5. Setting up a Default to populate field with data from Previous Record in a Form

6. Auto increment new field value based on yes/no field value

7. Auto Convert Old Field Value to New Field Values

8. Auto populate a from field based on subform field

9. Populate fields on one form with values from another form

10. !Populate some fields on a form with fields of another form

 
Powered by phpBB® Forum Software © phpBB Group