Access 2003 - double click textbox in a form to display a specific record

[Jpipher]

Let me explain what I am trying to accomplish...

Two forms -- we'll call them "Main" and "Related"

A command button on "Main" runs a union query.
The union query results are shown in "Related" in Datasheet view.
I want to then double click on the textbox [Related]![rltdIDNum] and
either move [Main]![IDNum] to that specific record or if I need to I am
willing to open another form showing the same information.

There is another post with the same subject line in this forum, however
I am still missing something. I am not sure if it has to do with
OpenArgs, or what.

If someone could explain what I need to for both tables. I believe I
have given you all the parameter information that will be necessary. If
not, let me know and I'll provide whatever is necessary.

thank you in advance.

[Jpipher]

I would prefer that it would just update the original form. So far
following as many of the suggestions that I have found the forums, I
can get the double click to open the form but there are still two
problems.

1) It isn't going to the specific record and

2) It stops the find function from working, which means it is acting
like a query rather that a "find" type function. I need the latter.

thanks again.
Jp*****@gmail.com wrote:

Let me explain what I am trying to accomplish...

Two forms -- we'll call them "Main" and "Related"

A command button on "Main" runs a union query.
The union query results are shown in "Related" in Datasheet view.
I want to then double click on the textbox [Related]![rltdIDNum] and
either move [Main]![IDNum] to that specific record or if I need to I am
willing to open another form showing the same information.

There is another post with the same subject line in this forum, however
I am still missing something. I am not sure if it has to do with
OpenArgs, or what.

If someone could explain what I need to for both tables. I believe I
have given you all the parameter information that will be necessary. If
not, let me know and I'll provide whatever is necessary.

thank you in advance.

[Jpipher]

Fixed problem 2... but still am not going to requested record in the
opened form.

JP
[e-mail] wrote:

I would prefer that it would just update the original form. So far
following as many of the suggestions that I have found the forums, I
can get the double click to open the form but there are still two
problems.

1) It isn't going to the specific record and

2) It stops the find function from working, which means it is acting
like a query rather that a "find" type function. I need the latter.

thanks again.
Jp*****@gmail.com wrote:

Let me explain what I am trying to accomplish...

Two forms -- we'll call them "Main" and "Related"

A command button on "Main" runs a union query.
The union query results are shown in "Related" in Datasheet view.
I want to then double click on the textbox [Related]![rltdIDNum] and
either move [Main]![IDNum] to that specific record or if I need to I am
willing to open another form showing the same information.

There is another post with the same subject line in this forum, however
I am still missing something. I am not sure if it has to do with
OpenArgs, or what.

If someone could explain what I need to for both tables. I believe I
have given you all the parameter information that will be necessary. If
not, let me know and I'll provide whatever is necessary.

thank you in advance.