Refine a Double Click Event From Subform to Form - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Refine a Double Click Event From Subform to Form

Kirk Barry

6 months ago

While on a subform, I created a double click event in a databox to open a form. When I double click, I get a dialog box that instructs me to "enter parameter value" I would prefer it if the double click event took me directly to the form. What did I do wrong?

Private Sub SampleNumber_DblClick(Cancel As Integer)
DoCmd.OpenForm "StandardCannProductF", , , "SampleNumber=" & SampleNumber
End Sub

	Donald Blackwell @Reply 6 months ago
Verify the spelling of the name of the field in the table or query the form is based upon. I.E. even though it is spelled "SampleNumber" in the form you are double clicking, is that the spelling of the field in the control source of the form that you are opening...

	Richard Rost @Reply 6 months ago
Also make sure SampleNumber is a NUMERIC value and not text. Otherwise you need double-double quotes. Concatenation

	Kirk Barry OP @Reply 6 months ago
Thank you both kindly. I will address this immediately

	Kirk Barry OP @Reply 6 months ago
And the answer is.........double quotes. The table field is a short text field. So I added quotes to the SampleNumber at the end of the string and presto, it works great Thank your for helping me on my continuing mission to explore the strange new world of coding and string concantisomething or other......James Kirk star date 20251005.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View