Using 'Seek' in DAO with linked tables

[Guest_imported]

Hello
I have a form that uses dao to access two tables and seek a particular record from each.
Set dbMyDBase = CurrentDb
Set rsMyRSet1 = dbMyDBase.OpenRecordset("tblParts&quot
Set rsMyRSet2 = dbMyDBase.OpenRecordset("tblPartList&quot
rsMyRSet1.Index = "PrimaryKey"
rsMyRSet1.Seek "=", Me.cboProductID
rsMyRSet2.Index = "PrimaryKey"
rsMyRSet2.Seek "=", Me.tbxPartOrderID, Me.cboProductID
The following code works fine when the tables are within the current DB (not linked) as soon as i split the database i get the following error message: Operation is not supported for this type of object.
Im just wondering why the following code will not work on a linked table. Any suggestions would be greatly appreciated.

 

[jebry]

Hi!

It doesn't work because you cannot open a linked table using dbOpenTable. You can open it as a Dynaset using dbOpenDynaset. To find the record you need you will want to use the FindFirst method. The general format is:

rst.FindFirst "YourIDField = '" & Me!YourControl & "'"

The code above assumes that the ID field is text. If it is numeric, leave out the single quotes.

hth
Jeff Bridgham
bridgham@purdue.edu