Recordsets

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

I have a code to get the information that meets the
criteria:

Set rs = CurrentDb.OpenRecordset("Select
CO_NUMBER,CUS_PO, SHIP_ID, PROM_DLVRY, LN_STA,
PRICE_LEVEL, CSR, SHIP_VIA, FREIGHT, TERMS, CONTACT,
CONTACT_PHONE from tblNEWORDERS where AFLAG = '-1'")

stDocName = rs("CO_NUMBER")
c = rs.RecordCount

When I do a msg box for # record count it only give me 1
which there are 2 records. Should I use something else
aside from OpenRecordset so it will give me all the
records that has -1? I am trying to have a code that will
evaluate if it meet the criteria do this and then move to
the next record.

Any ideas?
 
try adding

rs.MoveLast (i think that's the method)

before the RecordCount method. if that doesn't work, try

rs.MoveFirst
rs.MoveLast

before the RecordCount method. if that doesn't
work....maybe somebody else will step in...! :)
 
Back
Top