Michael R Mattys
mmattys at rochester.rr.com
Mon Feb 12 14:15:07 CST 2007
Hi Kostas, The next line, then, would be Forms(stdocname)!AM = Me!AM Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: "Kostas Konstantinidis" <kost36 at otenet.gr> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Monday, February 12, 2007 2:43 PM Subject: [AccessD] How to transfer text.. > hi group, > On a double click on a form I use the follown: > > Private Sub AM_DblClick(Cancel As Integer) > Dim poustia As String > Dim stdocname As String > > stdocname = "MT_basic_char" > If IsNull(num_mitroou) Then > DoCmd.OpenForm stdocname > DoCmd.GoToRecord acDataForm, stdocname, acNewRec > else > poustia = Me!num_mitroou > DoCmd.OpenForm stdocname, , , "num_mitroou= " & poustia > End If > End Sub > > > what I want to do is after the new record update and closing the > stdocname > the text of AM's field to be tranfered to the AM field of the opened form > > Many thank's > /kostas > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com