Blank Queries with function Attachments
Here is my problem. I created a query in Access. In that
query in the criteria field I enter Retest - ISS* and data
gets pulled up. I'm trying to code it in
VBA so that i
can select from a drop box and from the drop box you can
select Retest - ISS* or Retest - INT*. Here is my code
Public Function get_ReTestName() As String
get_ReTestName = ReTestName
End Function
get_ReTestName is now currently in the criteria field but
when i do it this way i get nothing.
The following code I hardcoded to try to trouble shoot the
problem but I still get nothing..... here it is
Public Function get_ReTestName() As String
ReTestName = " """ & "Retest - ISS*" & """ "
MsgBox ReTestName
get_ReTestName = ReTestName
End Function
Let me know if you may have a solution.
Thanks,
tony
.
