Object does not support this property or method (1 Viewer)

[JoseSharp]

Hi, I have recently transfered an MS Access d'base to SQL. Within the original MS d'base there was a list box that allowed users to select d'base entries and the details of the selection where then displayled. The code was

ynListSel = True
Dim rs As Object

With frm
Set rs = .Recordset.Clone
rs.FindFirst "ID = " & !lstRecords
.Bookmark = rs.Bookmark
!cmdNewRecord.Enabled = True
Since the transfer to SQL the list box code is no longer working and I get the error:-
End With

Set frm = Forms!frmMain
varInvoiceRef = frm!lstRecords



Object does not support this property or method

Does anyone know why???

 

[pdx_man]

If moving to a SQL backend is the only thing that changed, then I would look at security. How are you authenticating the users on SQL? What permissions does there login have? What happens if you grant this user sa rights?

What is frm defined as?
What line is generating the error?