campanellisj
Registered User.
- Local time
- Today, 11:43
- Joined
- Apr 28, 2010
- Messages
- 23
Morning and thanks for any help in advance.
I have a form called frmPMR that has a list box (SearchResults) in it that I am trying to configuare with the dbl click event. I would like the user to be able to dbl click an item in the list and have a smaller form (frmPmrPop) open displaying more information about the item selected.
I have the following code assigned to the dbl click event of the list:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPmrPop"
stLinkCriteria = "[ID]=" & Me![SearchResults]
DoCmd.OpenForm stDocName, , , stLinkCriteria
I get an error when executing that highlights the last line in yellow. The information in the list is from a query that selects every field from a table (tblBenning).
What am I doing wrong?
I have a form called frmPMR that has a list box (SearchResults) in it that I am trying to configuare with the dbl click event. I would like the user to be able to dbl click an item in the list and have a smaller form (frmPmrPop) open displaying more information about the item selected.
I have the following code assigned to the dbl click event of the list:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPmrPop"
stLinkCriteria = "[ID]=" & Me![SearchResults]
DoCmd.OpenForm stDocName, , , stLinkCriteria
I get an error when executing that highlights the last line in yellow. The information in the list is from a query that selects every field from a table (tblBenning).
What am I doing wrong?