values from previous record in a current record

[jaanisf]

Hi, a have a problem i cannot resolve. Imagine a have a table with fields [name] and [surname]. Now, in form view, when I want to edit or add new records I have two text boxes named "name" and "surname". The problem is, I need another one text box, wich shows, for example, a [name] value for a previous record.

 

[Mile-O]

You'll need to use DAO or ADO to create a clone of your form's recordsource.

Using the clone you can move around the cloned recordset without the user physically knowing and can take values from fields and place them in variables or on your form.

Try searching on this forum for Clone or RecordsetClone.