Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
copiying fielddata from a previous record
3 views
Skip to first unread message
Sonimage
May 4, 2010, 1:18:49 PM5/4/10
to
How can I make a in Access 2007 (Vista Business) :
Private Sub name_DblClick(Cancel As Integer)
wich copies the value of the field familyname in the previous record and
place this value in the field familyname of the current record?
Private Sub name_DblClick(Cancel As Integer)
wich copies the value of the field familyname in the previous record and
place this value in the field familyname of the current record?
With kind regards
H.Benning
Sonimage
Alex Dybenko
May 6, 2010, 7:01:51 AM5/6/10
to
Hi,
you can use DLast function:
you can use DLast function:
me.FieldName=dlast("FieldName", "mytable","ID<" & me.ID)
where ID is a primary key
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"Sonimage" <Soni...@kpnmail.nl> wrote in message
news:ukSZc36...@TK2MSFTNGP04.phx.gbl...
0 new messages