By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Dec 3 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Dec 3 '06 #2

P: n/a
Fixed problem 2... but still am not going to requested record in the
opened form.

JP
Jpip...@gmail.com 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.
Dec 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.