Populating selected form fields from previous record

[Istari]

Hi all

I'd like to place a button on a form which would grab the values of selected
fields from the previous record.

Not sure how to gho about this.

Thanks

Istari

 

[Kevin Sprinkel]

I'd like to place a button on a form which would grab the
values of selected

fields from the previous record.

Istari

Hi, Istari.

1. Use the Form AfterUpdate event to read the values of
the controls of interest for the "soon-to-be last" record
into an array. Use the Form On Current event or a command
button to write these controls to the new record.
2. Create your own data type and do the same.

HTH
Kevin Sprinkel

 

[Emilia Maxim]

I'd like to place a button on a form which would grab the values of selected
fields from the previous record.

Not sure how to gho about this.

Istari,

how do you define the previous record? Is there some date/time field,
or some number with a meaning? I'm asking this because the order of
the records in a form depends on how they are sorted in the underlying
table or query, plus the user might sort (and maybe also filter) them
too.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de