Move a record from a form to other form.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Orlando - 21 Mar 2007 00:40 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 21 Mar 2007 04:02 GMT

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

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hi, I have a form with a text box to search the records, what I'd like to
> do
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message