[AccessD] How to transfer text..

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 




More information about the AccessD mailing list