hi...i need to lookup data in an access database by a unique field, display the data, then change a certain field...does anyone have an idea on how to start this project?...i need to open a database, display the row, and change one field...im using access 97...is this a correct way to open?...
-------------------------------------------------

Private Sub Form_Load()

'Create and set the Recordset object
Set objRec = New ADODB.Recordset
Set objRec.Source = objComm
objRec.LockType = adLockOptimistic

'set cursor type
objRec.CursorType = adOpenDynamic

Set objConn = New ADODB.Connection
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & "Data Source=C:\test\test.mdb"
Set objRec = objConn.OpenRecordSet("Orders")

End Sub

-------------------------------------------------------------

thanks for your time...

can u make it more precise? i mean how the data to be displayed, on what control or something then what specific fields..just give example...tired of thinking any example right now...