Move a record from a form to other form.

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top