Update a field in table

[Mike]

Hi All,

How do I update a specific record by using codes.

The code is:

Dim db As DAO.Database
Dim username As Recordset

Set db = Currentdb
Set username = CurrentDb.OpenRecordset("User",
dbOpenDynaset)


With username
'What code do I need to add so that I can update the
username field with the userId'
End With



Thanks,

mike

 

[Allen Browne]

Use a SQL statement your recorset contains only the record you need to edit:

Set username = CurrentDb().OpenRecordset("SELECT * FROM User WHERE ...

Alternativley, you can FindFirst in the recordset, but that would be less
efficient than just fetching the one you need.

 

[mike]

Thanks

-----Original Message-----
Use a SQL statement your recorset contains only the record you need to edit:

Set username = CurrentDb().OpenRecordset("SELECT * FROM User WHERE ...

Alternativley, you can FindFirst in the recordset, but that would be less
efficient than just fetching the one you need.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.