[AccessD] Error 3070 - field not recognized

Rocky,

I just to get slight glitches with similar code in VB6 not sure if this will
solve the problem, but try putting square brackets around the field name
like below:

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

Hope it helps.

Paul

On 12 October 2010 18:47, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> 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/>
>
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>


-- 
Paul Hartland
paul.hartland at googlemail.com