finding specific record in a linked table

[klnlsu]

From what I have read, I understand you can't use the seek command on a recordset from a linked table from another database. Is that true? If so, what is the alternative to find a specific record in the table using an indexed field?

 

[SOS]

From what I have read, I understand you can't use the seek command on a recordset from a linked table from another database. Is that true? If so, what is the alternative to find a specific record in the table using an indexed field?

Dim rst Object
 
Set rst = Me.RecordsetClone
 
rst.FindFirst "[FieldNameHere]=" & CriteriaValueHere
 
If rst.NoMatch Then
   Msgbox "Record Not Found"
Else
   Me.Bookmark = rst.Bookmark
End If
 
rst.Close
Set rst = Nothing

 

[klnlsu]

Opening my recordset this way, will I be able to make changes to the record and write them back?

 

[SOS]

Opening my recordset this way, will I be able to make changes to the record and write them back?

The code I gave just takes you to the record. If the form is set to allow edits and your underlying record source for the form is updatable, it would be editable.

 

[klnlsu]

What is the fastest and most efficient method to access and update a record in a SQL table using VBA?