Opening a recordset (1 Viewer)

grenee · Sep 20, 2017

Good Day All,
Can someone explain why this code results in no records returned when the table has several records. And if the criteria is excluded all the records are returned.

Code:

  Set rst = curDatabase.OpenRecordset("Cash posting Sub Table", "[mainPostingID] =" & 7)]

MarkK · Sep 20, 2017

The DAO.Database.OpenRecordset method takes four parameters, but none of them are the SQL selection criteria. That is meant to be written into the SQL's WHERE clause, maybe something like...

Code:

   Const SQL as string = _
      "SELECT * FROM [Cash posting Sub Table] WHERE mainPostingID = "

   Set rst = CurrentDb.OpenRecordset(SQL & 7)

See what's happening there?
Mark

Opening a recordset (1 Viewer)

grenee

Registered User.

MarkK

bit cruncher

Similar threads

Users who are viewing this thread