Populating selected form fields from previous record

  • Thread starter Thread starter Istari
  • Start date Start date
I

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
 
I'd like to place a button on a form which would grab the
values of selected
fields from the previous record.
Click to expand...
Istari
Click to expand...

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
 
---------- "Istari said:
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.
Click to expand...

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
 
Back
Top