Error with Recordset.FindPrevious

B

bg_ie

Hi Folks,

The following line is giving me and error -

Me.Recordset.FindPrevious "New-Lab = True"

due to the presence of the '-'.

Me.Recordset.FindPrevious "OurLab = True"

works just fine.

So, how should I escape the '-'? I could rename the field to NewLab
but I'm worried that this field might be explicitly used somewhere
else in the database (which I haven't writen).

Thanks for your help,

Barry.
 
Top