473,320 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Double Click on a Record in a Subform to Open that record in a new form.

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.

Are there any examples that I might be able to view or any suggestions
would make my Holidays be great.

Thanks

Norris
Nov 12 '05 #1
3 36040
Your subform should have a primary key like OrdersDetailsID. In your different
form, you should have that same field as the primary key. Then in the Double
Click event of one of the records in the subform, put this code:

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "NameOfDifferentForm",,,"[OrderDetailsID] = " & Me!OrderDetailsID

--
PC Datasheet

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.

Are there any examples that I might be able to view or any suggestions
would make my Holidays be great.

Thanks

Norris
Nov 12 '05 #2
Absolutely FANTASTIC!!

Thank you so much for your help. It worked exactly like I hoped it
would. Now can you do any thing for my typing skills. :-)

Thanks

Norris
Nov 12 '05 #3
It doesn't look like you need Spell Checker or Grammar Checker!!

Steve
PC Datasheet
"N. Graves" <ng*****@yahoo.com> wrote in message
news:jk********************************@4ax.com...
Absolutely FANTASTIC!!

Thank you so much for your help. It worked exactly like I hoped it
would. Now can you do any thing for my typing skills. :-)

Thanks

Norris
Nov 12 '05 #4

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

Similar topics

1
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
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,...
13
by: MLH | last post by:
I have a form, frmVehicleEntryForm. On it is a subform control named frmAddnlOwnrListSubForm. The subform control's source object is frmAddnlOwnrListSubForm. When I click on the subform control,...
4
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...
13
by: jmpigott | last post by:
I have searched forever trying to solve a problem that simplifies recurring info inputs to my database the basic structure is Orders tbl main form and pricing_tbl subform and third when orders...
3
by: z.ghulam | last post by:
Hi, I have a PROBLEM form with a TASK table embedded as a subform. Each problem can have many tasks. What I'm trying to do is when I double-click on the task ID, the TASK form opens up on that...
3
by: Zippy | last post by:
I have recently moved from A97 to A2003. I find it inconvenient that I can no longer double-click on the subform to open it in full view. I had a hunt around the newgroups and couldn't find...
19
WyvsEyeView
by: WyvsEyeView | last post by:
Okay, now I need to open a form (frmTopics) and select the same record that has been double-clicked on in a separate form (frmTopicsFound). Here are the details: frmTopicsFound contains datasheet...
3
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....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.