Need to populate a new record on a subform with same data from the previous record

[Secue]

Hi:

I have a table with some header data and a subtable, I have an optio for users to enter new data on the subform for an especific ID on the main table. What I need to know is what is neede to work as I need:


- When I open the form to add data on the subform, I need to have this subform set to add a new record, but with some fields already populated with the same information for that field on the previous record.

Not sure If this is clear.

Thank you.

[June7]

That will require code to find the 'previous' record and populate fields of the new record.

What determines the most recent previous record - a date, an ID number.

[Secue]

June7

It could be a date or a field I have which is the revisión of the docuemtn (my dtabase is to control some docuemtn versions). ID is not piossible to be use, since this is the link form my child table with the main table.

I could have a record on my main table with some basic information, the I have a child table linked by the ID where I'm adding infomrtion for each revisión on the document.

I want to ente to my form to add a new revisión, them I look for ID and form display's part of the main table and the secondary table as a subform, on this subform I have it set as to show a new record to entry data, I need to have populated this subform with the information of the previous record ( for example the infomtion for the Revisión A of the docuemnt), so the user can change any of the data on the other fields (mainly Revisión and dates).

I see in other thread a lonk to a nother page explainig something similar, bu it dis not work for me, unless I did something wrong. this is the address: http://access.mvps.org/access/forms/frm0012.htm

Thank you.

[June7]

No, that is relevent only when manually entering data to a new record and want values carried forward to subsequent records in the same session.

You want form to open to new record with data filled in from existing record. This is trickier. I am sure this has been discussed in forum but not finding threads so I googled: access vba how to find last record.

This example http://p2p.wrox.com/access-vba/72604...ed-record.html shows code that opens a recordset in VBA, moves to the last record, pulls data from recordset fields and populates the new record. As always, the real trick is figuring out what event to put this code in.

[Secue]

I found the answer using function DLAst.
http://www.techonthenet.com/access/f...main/dlast.php

Thak you.

[June7]

Be careful with DLast. It can return unexpected results.