I have created a query called CinfoQuery in Access 2000 where I joined two tables Cinfo and CDetail with the following fields;
Cinfo.Company, CInfo.IPO, CDetail.City, CDetail.State, they are joined by the same ID; CinfoID = CDetailID "Not A Problem"
On the VB Form I have connected to the CinfoQuery table with an ADO control and then linked a DataGrid to the ADO control as well
The ADO Control is Set to CommandUnknown, ClientSide Cursor with the SELECT Statement for the RecordSource as Follows "SELECT * FROM CinfoQuery"
When the form opens or userID from another table changes a Query
triggers to update the grid with similiar info.
For example:
When a record opens with the field value of the txtState.Text = "NY" the grid only shows the records for the state of NY.

When I try to query by multible variables like State and City I create a error "ADODC Unknown Error ADO "

Is this because this is a defined Query in Access and I can only define the query by one variable????

Looking for some direction on this.

Other "Non query tables allow for SQL statements with mult variables. Is this because of the Right Join in the Access Query?????

Thanks

Bill