search information in another Form

[jaspervdh]

Hello,



I have made an film with what i want:



The video is made with powerpoint and screenshots, so it's not working in the real database.

Ps i'm dutch that's why all the words in the film are in dutch.

[aytee111]

I'm not sure that I have understood this! It looks like : on click event of the form you want to populate the first form with the value in the row they selected.

[jaspervdh]

I think that's a good explanation

[aytee111]

Is this solved then?

[jaspervdh]

No, on the film it are screenshots and paste in powerpoint and that is filmed.

[aytee111]

What in post#2 are you unable to do?

[jaspervdh]

No, I don't know how i have to do it.

[aytee111]

In the "OnClick" event of the second form, choose Event Procedure and add this code (change "form1" to the name of your first form, change "Text4" to the name of the control on the first form, change "Field2" to the name of the field on the second form):

Private Sub Form_Click()
Forms!form1!Text4 = Me!Field2
DoCmd.Close
End Sub

[jaspervdh]

Aytee111

You're the hero of the day! Thanks!

[aytee111]

You're welcome.