Double click function in a combo box

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
Chrisjack001Asked:
Who is Participating?
 
pdebaetsCommented:
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
 
pdebaetsCommented:
From your StudyID control OnDblClick event procedure, put

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

Open in new window

0
 
Chrisjack001Author Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
pdebaetsCommented:
Open the row source of your "Studies-Edit" form as a query in datasheet view. Do you see the same parameter prompt?
0
 
Chrisjack001Author Commented:
I dont understand what you mean. I am fairly new to Access. Can you please explain in detail what you mean
0
 
pdebaetsCommented:
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
 
Chrisjack001Author Commented:
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
 
Chrisjack001Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.