?
Solved

Double click function in a combo box

Posted on 2011-10-05
8
Medium Priority
?
331 Views
Last Modified: 2012-05-12
I have a form called “Scheduling-Edit”. Whe the record has a study in the “StudyID” field I want to be able to double click in that field to open the “Studies-Edit” form to that record. How can I accomplish this goal. Attached is a copy of the database with the forms .
Invoice-7-7-2001-91611.accdb
0
Comment
Question by:Chrisjack001
  • 4
  • 4
8 Comments
 
LVL 12

Expert Comment

by:pdebaets
ID: 36920109
From your StudyID control OnDblClick event procedure, put

docmd.OpenForm "Studies-Edit",,,"StudyID = " & me!StudyID

Open in new window

0
 

Author Comment

by:Chrisjack001
ID: 36920332
When I put this code in and double clicked I get another box popping up asking me to put parameter value in. Attached is a copy of the error message
Error.JPG
0
 
LVL 12

Expert Comment

by:pdebaets
ID: 36920485
Open the row source of your "Studies-Edit" form as a query in datasheet view. Do you see the same parameter prompt?
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 

Author Comment

by:Chrisjack001
ID: 36920575
I dont understand what you mean. I am fairly new to Access. Can you please explain in detail what you mean
0
 
LVL 12

Expert Comment

by:pdebaets
ID: 36920753
Open the "Studies-Edit" form in design mode.

In the form properties sheet, find the Row Source property.

If it is a query, find the query in the Navigation Pane and open it.

If it is an SQL statement ("Select ... From ..."), copy the SQL text and paste into a new query (Create > Query Design > (close "Show Table" dialog) > SQL, then paste). Open it in datasheet view.
0
 

Author Comment

by:Chrisjack001
ID: 36920904
I dont think its a query. The record source is the Studies table. Attached is the screen of my form and properties.
Error.JPG
0
 
LVL 12

Accepted Solution

by:
pdebaets earned 2000 total points
ID: 36921052
I think the parameter prompt is coming from elsewhere.

Try this in your StudID OnDblClick event procedure instead of what I posted above:

DoCmd.OpenForm "Studies-Edit", , , "Studyautonbr = " & Me!StudyID

Open in new window

0
 

Author Closing Comment

by:Chrisjack001
ID: 36921199
Thanks
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question