value from form to anther form

penobepo

New member
Local time
Yesterday, 22:17
Joined
Jan 5, 2006
Messages
6
i wanna get value from form to anather form bu using query and using order
"Enter" or "duble click"
can u help me ??
 
penobepo said:
i wanna get value from form to anather form bu using query and using order
"Enter" or "duble click"
can u help me ??

Did you mean:
Translation said:
I want to fill a value in a field on form A with a value in a field on form B executed by the OnEnter or OnDoubleClick Events

If you did, the task is simple.

Code:
Public Sub FormA_OnEnter()
   If Forms!FormB!txtField <> Null
       Me!txtMyField = Forms!FormB!txtField
   End If
End Sub
 
If Forms!FormB!txtField <> Null
will NEVER return true even when txtField is null. If you need to check for null, use the IsNull() function.

If Not IsNull(Forms!FormB!txtField) Then
...
 
i can it
but it no work
can you send example
and
thanks
 
I don't think your request is clear enough for someone to create a sample for you.
 
thank uoy
i can creat it yesterday
code in form B
***********
Private Sub Form_Unload(Cancel As Integer)
Forms!A!Text0 = Me!Text0
End Sub
---------------------------------------------
code in form a
***********
Private Sub Command5_Click()
DoCmd.OpenForm "B"
End Sub
 

Users who are viewing this thread

Back
Top Bottom