I am banging my head against the wall, and coming up with no ideas, so I figured maybe I could give you guys a new problem 
Okay, I have a search form, that allows the users to select from 4 different combo boxes. Once they select what they want to search against, they can click the "Search" button, and the resulting records appear in a list box below. They can then double click on the records in the list box to open the record in another form for editing purposes. It works great.
But they have entered some records with apostrophes. In a MS Access database, I would simply use the function chr(34) for quotes and I could allow the users to search against the apostrophes. chr(34) does not work with an ADP though.
So I built a stored procedure using the SET QUOTED_IDENTIFIER ON to allow the users to search against the apostrophe. It works great, but I cannot set the stored procedure as the recordsource for the list box based on what the users select.
Has anyone ever set a list box's property equal to a stored procedure, in which the values can change by parameters entered on the form?
Thank you for your time,
T.J.
Okay, I have a search form, that allows the users to select from 4 different combo boxes. Once they select what they want to search against, they can click the "Search" button, and the resulting records appear in a list box below. They can then double click on the records in the list box to open the record in another form for editing purposes. It works great.
But they have entered some records with apostrophes. In a MS Access database, I would simply use the function chr(34) for quotes and I could allow the users to search against the apostrophes. chr(34) does not work with an ADP though.
So I built a stored procedure using the SET QUOTED_IDENTIFIER ON to allow the users to search against the apostrophe. It works great, but I cannot set the stored procedure as the recordsource for the list box based on what the users select.
Has anyone ever set a list box's property equal to a stored procedure, in which the values can change by parameters entered on the form?
Thank you for your time,
T.J.
