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.

Dec 3 '06 #1

Subscribe Reply

3366

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.c om 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

Jpipher

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

JP
Jpip...@gmail.c om 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.c om 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

Similar topics

4721

Error Trapping In Access 2000

by: Peter Frost | last post by:

Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance

Microsoft Access / VBA

4708

Selecting only one page out of a several-page report for printing - how to route in Access?

by: Sami | last post by:

I hope someone will tell me how to do this without having to do any VB as I know nothing in that area. I am a rank beginner in using Access. I have created a database consisting of student athletes. I have now learned how to join two different tables in a query so that I might generate a report. Specifically, student athletes at a...

Microsoft Access / VBA

2182

Typing SQL Tables in by hand, in Access

by: Alicia | last post by:

If I wanted to create a table by hand create table temp( etc, where do I do it in access?

Microsoft Access / VBA

2915

Insert into Access with C#

by: Abareblue | last post by:

I have no clue on how to insert a record into access. here is the whole thing using System; using System.Drawing; using System.Collections; using System.ComponentModel;

C# / C Sharp

2664

How will we use .Net in future versions of Access

by: Lyle Fairfield | last post by:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/callnetfrcom.asp The Joy of Interoperability Sometimes a revolution in programming forces you to abandon all that's come before. To take an extreme example, suppose you have been writing Visual Basic applications for years now. If you're like many developers,...

Microsoft Access / VBA

9176

Access 2003 - opening a form to show specific record

by: MartinR | last post by:

Hi, I'm still new to writing code in vba as I've only been introduced to access three weeks ago. I have written this code below and it executes but does not do what I want it to do. What I want is the form "Sparesform" to open when I double click on the "index" field for the record I wish to view. The index field is part of a subform. What is...

Microsoft Access / VBA

3175

Help with double click event

by: Jim Devenish | last post by:

I have an unbound form that displays all the days of the year as a calendar. It has 12 rows of text boxes with either 29,30 or 31 in each row. Text box names are of the form: display_01_01, display_01_02 ... display_12_31. This is used to display bookings of holiday properties and works well. I am now wishing to be able to highlight a...

Microsoft Access / VBA

5157

Opening Excel from Access

by: Phil Stanton | last post by:

I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub Storage_Click() On Error GoTo Err_Storage_Click

Microsoft Access / VBA

3260

Access 2002 won't create new record

by: tekctrl | last post by:

Environment; Win2K PC with 1Gb of RAM and plenty of HD space running Access 2002 Issue; Access presents a blank data entry form in the Forms view when the New Record icon is used. However, it won't allow any fields to have data entered into them. I can edit & save existing records without problem. When I go into the Tables view, I can add...

Microsoft Access / VBA

7527

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7726

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7819

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5097

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3505

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3488

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1953

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1064

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

772

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General