Move a record from a form to other form.

[Guest]

Hi, I have a form with a text box to search the records, what I’d like to do
is: I made another form ( Tabular) with the ID and Description, I would like
to open this form with a command button, click the record and move the ID
field to the search text box and after show all the data in the principal
form.

Thanks

 

[Arvin Meyer [MVP]]

You can just open the principle form using code from the continuous form.
The double-click event should do it (air code):

Sub ID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmPrinciple",,,"ID = " & Me.ID
End Sub