First - thanks for your email.
I tried the modification you suggested; however VB does not like the first part of the code.
If stLinkCriteria Like "[ID]= ""
& Me![Text0]
& "'" Then
stLinkCriteria1 = "[Name]="" & Me! [Text2] & " '
Table: (Sales_Site, Area_Codes)
I am trying to list area codes values associated to each sales site across a page (report). Access lists values vertically.
The code below fails to work properly. I don't recieve an error message, but, no data shows up on report. -
Option Compare Database...
Basically, I am trying to retrieve records related to information provided in 2 text boxes. So far - the code below fails to work.
I appreciate any help. Thank you.
On Error GoTo Err_Command4_Click
Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria1 As String...
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.