rickyoswald
Programmer
I have three tables; tblQryID, tblClients and tblCases. tblClients holds client info and tblCases holds case information while tblQryID holds a string from a VB app. There is a report called rptClientCases which holds information from the tables tblClients and tblCases, these are connected as one to many. I set up a query that held the criteria for tblClients, field "Name" :
(SELECT[ID]FROM[tblQryID])
So when the VB app sends a string to the field and runs the report it will only show the report with the name that matches that of the string sent by the VB app.
I have used the same query criteria in other parts of my database, they only work if there is one table involved (beside tblQryID). I am using Access 2003 on windowsXP with all the latest updates and such. I have searched on google and such but cannot seem to find anything on it.
(SELECT[ID]FROM[tblQryID])
So when the VB app sends a string to the field and runs the report it will only show the report with the name that matches that of the string sent by the VB app.
I have used the same query criteria in other parts of my database, they only work if there is one table involved (beside tblQryID). I am using Access 2003 on windowsXP with all the latest updates and such. I have searched on google and such but cannot seem to find anything on it.