pass value from form to any form

[basilyos]

hello

if i want to pass value from textbox in a form to another textbox in a form i use
Forms!Form1Name.FirstTextbox = Me.FirstTextbox

this works fine

but if i want to pass value from textbox in a specific form to any other form to a specific textbox for example txtname

i have a form contain the customers name
when i'm in any dialog i press shift+F1 so the customers form will open and when i double click on the chosen customer i want to get the name in that specific textbox in the form opened

 

[pr2-eugin]

You can use the OpenForm's OpenArgs argument.

DoCmd.OpenForm "yourFormName", OpenArgs:=Me.yourControlName

The in the Current event you can use

Private Sub Form_Current()
    If Len(Me.OpenArgs & "") <> 0 Then
        Me.yourControlName = Me.OpenArgs
    End If
End Sub

 

[basilyos]

ok sir i'll give it a try