[AccessD] How to transfer text..

Michael R Mattys mmattys at rochester.rr.com
Mon Feb 12 14:29:02 CST 2007


Oops, backwards isn't it?
In that case, why not declare a global variable in a module
that you can make equal to Forms("MT_basic_char")!AM
before you close it and then gather that to the open form ...

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Michael R Mattys" <mmattys at rochester.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, February 12, 2007 3:15 PM
Subject: Re: [AccessD] How to transfer text..


> 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
>
> -- 
> 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