Very Computer

How can a recordset be subjected to second query, with different fields?

A query runs on a table resulting in a record set (rs) which is displayed to
the user.
The user then chooses from that display, resulting in the recordset being
queried for a second time.

Thank You,

John Bigalke
Beatnik's

Two suggestions:
1. Use a second recordset on the same data source, then optimise the
two in terms of variables for what you want to do.
2. Don't use parameterised queries, but explicitly set the m_strFilter
variable.

HTH

Paul.
-------------------------------------------
Expressed opinions are usually my own.
Especially if they're any good (of course).
-------------------------------------------

Thank You SO much!!!

Is anything like this possible??
    m_TestDaoRecordset.m_strFilter = ("[CatID] =5"&&"[Page]=4");
    // (This doesn't work in it's present state)

Or do I need to try something like this?

    m_TestDaoRecordset.m_strFilter = "[CatID] =5";
    m_TestDaoRecordset.open();

    m_TestDaoRecordset2=m_TestDaoRecordset

    m_TestDaoRecordset2.m_strFilter = "[Page] =4";
    m_TestDaoRecordset.open();

Thank You,
John Bigalke

m_strFilter is a CString, so it needs text. "[CatID] =5"&&"[Page]=4"
is attempting to produce a logical. Use "[CatID]=5 and [Page]=4", ie a
normal SQL WHERE clause.

HTH

Paul.
-------------------------------------------
Expressed opinions are usually my own.
Especially if they're any good (of course).
-------------------------------------------