Win98 does'nt like my db

[naygl]

Win98 doesn't like my db

My Access 2000 db is playing up on computers that have windows 98 installed. Combo boxes are not able to find records. In the after update event I have code like this:

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[JobID] = " & str(Me![CmbJobID])
Me.Bookmark = rs.Bookmark

It works fine on the Win2000 computers. I think it has to do with the references (i.e DAO) but I'm not sure. I can't check it myself as the network is at the other end of the country so I would appreciate some ideas that I could pass on.

 

[DJN]

Try the following syntax.

Me.RecordsetClone.FindFirst "[JobID] = '" & Me![CmbJodID] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark

David

 

[Alexandre]

Try the following to test if this is a problem related to the ADO references: see if the Date() function returns an error (if so the DAO reference is missing). In module editing view, got to Tools -> References and check if DAO 3.6 or higher is selected as well as ADO 2.1 (or higher). Check that DAO is set above ADO in your list.

 

[naygl]

I have tried to emulate what I thought was the problem (ADO selected instead of DAO 3.6) but the comboboxes work fine on my computer. The only difference between computers in the network, I'm told, is the Windows versions. What else could stop a valid record being found?