[AccessD] Error 3070 - field not recognized

Dear List:

This has got to be something simple that I'm just not seeing because I've
used this technique for years with no problem.  But I'm stumped.

User selects a value from a combo box (in this case a lot number) and I use
.FindFirst and .Bookmark to set the record selector to the selected record
on a continuous form.  The combo box is on the main form, continuous form is
a sub form.  (BTW I tried putting the combo right on the subform but had the
same problem.)

Here's the code:

Private Sub cboLotSerialReferences_AfterUpdate()

Dim strSQL As String

strSQL = "fldLotSerialReference = '" _
        & Me.cboLotSerialReferences.Column(0) & "'"

MsgBox strSQL
        
Me.subfrmLotSerial.Form.RecordsetClone.FindFirst strSQL
Me.Bookmark = Me.RecordsetClone.Bookmark

End Sub


where fldLotSerial is a bound field on the subform.  The MsgBox shows
fldLotSerialReference = 'aaa'.  On the .FindFirst statement I get error 3070
- Microsoft Jet database engine does not recognize 'fldLotSerialReference'
as a valid field name or expression.

Any clues?

 

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

Skype: rocky.smolin

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>