Anybody know whats wrong with this line? 1

[Frank72]

hows it going?

Set Rst1 = CustDb.OpenRecordset("SELECT firstName , secondname , a1 , a2 , customerid From dbo_tblcustomer" & "ORDER BY firstname", dbSeeChanges)

error msg "invalid argument"

any help appreciated

thanks

frank

 

[Mossoft]

Set Rst1 = CustDb.OpenRecordset("SELECT firstName , secondname , a1 , a2 , customerid From dbo_tblcustomer" & " ORDER BY firstname", ,dbSeeChanges)

dbSeechanges is an "Options" value not a "Type" value so has to be third parameter.

Also probably need space between "dbo_tblCustomer" and "ORDER".



M.