What kind of tables are you linking to? We had the same problem with Oracle linked tables. We had to install the ODBC driver from Oracle to eliminate the problem. What a bear that is!
You can still use the code I provided by pointing to the text box where the criteria is being typed.
Here's the function we use:
Function RptProject() As Integer
RptProject = IIf(IsNull(Forms![frmReportsAvailable]![lstProject]), 0, Forms![frmReportsAvailable]![lstProject])
End Function
We...
Here's what we use:
Like IIf(RptProject()=0,"*",RptProject())
where RptProject() is function that gets the value of a list box selection from the form that gives the user parameter choices. You can just fill in the values from what the user enters, also.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.