[AccessD] Error 3070 - field not recognized

Paul:

Now I wish I had that bad boy still in the table.  I'd try that.  I had a
feeling there was a special character embedded somewhere in the field name.
Although the odd thing was that I would copy the field name right out of the
table and paste it into the code - so you'd think no matter what was odd
about the field name that oddity would get dragged along on the copy and
paste.  Oh well, I'll probably never know.  On to the next anomaly...

Rocky
  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland
Sent: Tuesday, October 12, 2010 11:24 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com