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

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

P: n/a
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
Share this Question
Share on Google+
3 Replies

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

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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.