where in recordset

[samotek]

I have the following recordset:

Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("SELECT Productid, code, categoryid,supplierid, size, ddu, grossprice,

office,cons,vip,dealer,pref ,bosch,drummer,oem,rig FROM products")

' fix office prices
rs.MoveFirst
Do
.............
I need to fix up the prices only in those cases where supplierid = 2.how can i change the recordset?

 

[Golom]

Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset( _
   "SELECT Productid, code, categoryid,supplierid, _
           size, ddu, grossprice, office,cons,vip,dealer, _
           pref ,bosch,drummer,oem,rig _
   FROM products _
   [red]WHERE Supplierid = 2"[/red])

I don't know what you want to do to "fix up" the records but an UPDATE statement may be what you need.

 

[samotek]

It works! Thank you !