473,748 Members | 4,935 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Click on record in a subform datasheet to open another form displaying info related to that record???

I have a form which displays a subform datasheet of information. I'd like
to be able to quickly click on a particular record and open up another form
showing more detailed information about that record from a related table.

Is there a way to do this? It would be nice to be able to right click on a
cell in a datasheet and then select menu choice to open a form with related
information, but it seems like to right click menues in Access are hardwired
for Access application functionality.

Is there some other way to accomplish the same thing? Again, I just want to
be able to quickly click on a record/cell in a datasheet and open another
form to view expanded information related to that record from a different
table/query.

Thanks in advance for your help!

Ed Self


Nov 12 '05 #1
1 12061
It's easy to do with a continuous forms view, and using double click -- that
is illustrated in the sample databases for image handling in Access that you
can download from http://accdevel.tripod.com. I use a common procedure
called from the double-click event of each control and the detail section
itself so a double-click anywhere on the line will open the detail form. In
that procedure, you pick up the unique id and construct a DoCmd.OpenForm
statement's WhereCondition.

Larry Linson
Microsoft Access MVP

"edself" <ed****@ecomail .org> wrote in message
news:N2rwb.2931 92$Tr4.926313@a ttbi_s03...
I have a form which displays a subform datasheet of information. I'd like
to be able to quickly click on a particular record and open up another form showing more detailed information about that record from a related table.

Is there a way to do this? It would be nice to be able to right click on a cell in a datasheet and then select menu choice to open a form with related information, but it seems like to right click menues in Access are hardwired for Access application functionality.

Is there some other way to accomplish the same thing? Again, I just want to be able to quickly click on a record/cell in a datasheet and open another
form to view expanded information related to that record from a different
table/query.

Thanks in advance for your help!

Ed Self

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
36164
by: N. Graves | last post by:
Hello, I'm having trouble with a feature that I would like to add to my database. I would like to have the ability to double click a record on a Sub form and that action would open that specific record in different form. I have almost been successful using a Macro to do this but I have not been failure comes with not display the specific record that I have double clicked on.
5
5259
by: tdmailbox | last post by:
I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test box that is populated with the code =subfrm_media_review_sec_party.Form!first_name & " " & subfrm_media_review_sec_party.Form!last_name It works except that when I flip through the names it populates the parent form with the name of what ever...
9
9069
by: DS | last post by:
Whenever you use a continous form each row represents a record. Does this record have a number? If so how do you access it. Right now I have a field using auto number. But if access generates its own number for that row I'd like to use that. Thanks DS
3
15412
by: Typehigh | last post by:
I am a good programmer, but this one stumps me! I have a form with a continuous subform. The continuous subform contains records of data and may reach a depth of 1000's of entities. I have created a search button on my form and it does its job quite well. It presents the user with an inputbox, prompting for the string to search. Then the code returns with a record number of the record which contains the string. Here's the problem. I...
2
2559
by: whitc26 | last post by:
Let me preface: I'm a novice, and have no programming experience. I have created an access database and have a few tables in it. I have created a form called "clients" This form opens up and has alot of basic client information in it, nothing fancy, no code (other than what access has put in). I have created a second form "newVisit" This form has a subform on it called "client visit subform". The form is just to be used to record...
4
7570
by: Orv | last post by:
I have a search form which contains a non-linked subform. When I fill the criteria of my search and click the search button it returns the results in the subform, datasheet view. I then want to select/click on the row (record) on the datasheet and have that record pop-up. Any ideas? TIA,
4
6195
by: Savita23 | last post by:
Hi, I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can fire the double click event of Detail section of the subform from the main form?I can't find this event. As of now,I am invoking the procedure in the Form_DblClick event of the subform.But this invokes the procedure when I double click on any part of the subform.I...
1
1897
by: Gaurav Jhamb | last post by:
I have a JSP Page which displays a another Jsp datasheet of information. on button click. I'd like to be able to quickly click on a particular record and open up another JSP page showing more detailed information about that record from a related table. Is there some other way to accomplish the same thing double click on button? Again, I just want to be able to quickly click on a record/cell in a datasheet and open another form to view...
3
3609
by: thayes5150 | last post by:
I have an Access 2003 database used to research unemployment claims. The main form contains a subform in datasheet view listing the employee claim records, including employee Social security number. I would like them to be able to double Click a record in this datasheet and have it open a subform, populated from a Query that is passed the SSN from the recordset that was clicked. I have included the following code in the vba: Private Sub...
0
8830
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9541
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9370
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9247
tracyyun
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8242
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6796
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6074
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4602
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2782
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.