update record after select statement

[rwahdan@gmail.com]

Hi,

I did the following to get some operations done but since i did the selection, i stored one field value to string so i can update it, how is that done?

   Set dbsNorthwind2 = CurrentDb
   Set rstShippers2 = dbsNorthwind2.OpenRecordset("Units")


   rstSQL = "SELECT * FROM Units WHERE UnitID =" & msg & ""      
   Set rstShippers2 = dbsNorthwind2.OpenRecordset(rstSQL)
   
   rstUnitNumber = rstShippers2!UnitNumber
   rstUnitType = rstShippers2!UnitType
   rstLocationFloor = rstShippers2!LocationFloor
   IsOccupied = rstShippers2!IsOccupied                            this one i need to update, the rest i used to add to new table

Thanks,
Rami

[andy49]

What exactly are you trying to update here.

You haven't altered the recordset so I'm assuming it's the isoccupied

Is this a textbox on a form?

More details please.


Sent from my iPhone using Tapatalk