Using a Index on a linked Sql Table

[Razor1]

I have a sql table linked to my Database, dbo_Customers the primary index is PK_Customers.


When I run the code it errors on:
rstCustomers.Index = "PK_Customers"

I get the following error:
Operation is not supported for this type of object.
Here is the start of the code.

Set db = CurrentDb
Set rstActiveCustomers = db.OpenRecordset("ztbl_CodeGreen")
rstActiveCustomers.Index = "PrimaryKey"

Set rstProductSold = db.OpenRecordset("qry_Purchases")
rstActiveCustomers.Index = "PrimaryKey"
Set rstCustomers = db.OpenRecordset("dbo_Customers")
rstCustomers.Index = "PK_Customers"

Any help would be appreciated.

Razor1

 

[PHV]

Why do you want to use the Index property ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Razor1]

I need to get information from the customer table to use in a different table and query

Razor1

 

[PHV]

Why not use the FindFirst method ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Razor1]

I was not aware of that command. Thanks it worked!!!

Razor1