Move a record from a form to other form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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