473,498 Members | 1,741 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Double click and related form pop up

48 New Member
Access 2000. In a form, I have a subform showing simply names and contact numbers. I need a pop up contact form (related contact detail like job title, address, email..ect) when double click on a specific name. This pop up form will not show other contact person but will allow me to do editing or deleting on that specific person that I double clicked only.
How to do that?
Nov 12 '07 #1
2 2498
Lysander
344 Recognized Expert Contributor
Access 2000. In a form, I have a subform showing simply names and contact numbers. I need a pop up contact form (related contact detail like job title, address, email..ect) when double click on a specific name. This pop up form will not show other contact person but will allow me to do editing or deleting on that specific person that I double clicked only.
How to do that?
Assuming you have a numeric unique id for each person, say, Person_ID, then put a button in the detail section of the subform that opens a new form, say, frmFullDetails, that has all the fields you want to edit.

Then in the click, or double_click event of this button, use the code
Expand|Select|Wrap|Line Numbers
  1.     DoCmd.OpenForm "frmFullDetails", , , "Person_ID=" & Person_ID
  2.  
Nov 12 '07 #2
HowHow
48 New Member
The subform shows a name list that link to a company. If I am using button to open another form, say frmFullDetail within the subform, the frmFullDetail will show all the people from that company, which I don't want.

Is there anyway to see the specific person only when that person's name is double clicked?
Nov 12 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
4411
by: Dalan | last post by:
I probably just need a simple piece of code to do this as the couple tried so far have failed. I created a new Access 97 Form Filter (frmFilterForm) which displays most of the key data fields from...
1
12007
by: edself | last post by:
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...
2
2681
by: Uninvisible | last post by:
I have put together a db for a law firm to keep track of counterfeit activities. There are four parent tables: tblContact tblTransaction tblAction tblFile I have created a form,...
1
1748
by: Blacky | last post by:
Hi I have a small form with a listbox. When double clicking on an item, the item is added to another form and then the form is closed. But this creates an exception error saying that the ListBox...
3
11886
by: Young J. Putt | last post by:
I have a vb.net datagrid bound to a dataview on a windows form. I want to use the datagrid to display and filter a list of items, but since the data is complex, I don't want the user to edit the...
3
2393
by: Neil Wallace | last post by:
Hi, This is an odd one. I've been struggling to get "double click" to work well for my controls. The same event handler works perfectly for buttons, but not for labels. Can anyone tell me...
2
3358
by: Jpipher | last post by:
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"...
4
1544
by: Poldie | last post by:
I'm using Visual Studio 2005 SP1 on a Win2K SP4 system. VS is set up to use "web development settings ". I use VB. If I create a new web application project, then close the project and exit VS...
6
3162
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,...
0
7002
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...
0
7165
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,...
0
7203
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...
0
5462
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,...
1
4908
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...
0
3093
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...
0
3081
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1417
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 ...
0
290
bsmnconsultancy
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...

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.