You might try putting brackets around the field name like [CLIENT NAME].
This works in Access, not sure about VB. Hope this helps.
Quote:> I am having trouble with the Data1.REcordset.findfirst method if the
> criteria for the search contains a field name that has a space in it.
> For example suppose you have a databse table in microsoft Access with a
> field name called CLIENT NAME. That is two words separated by a space.
> Now suppose I want to use this code:
> Data1.Recordset.findfirst "CLIENT NAME = 'JONES'"
> It says SYNTAX ERROR.
> But suppose you change the name of the field to CLIENTNAME with no
> data1.recordset.findfirst "CLIENTNAME = 'JONES'"
> then it works perfectly!! What can I do if I want the space in the
> field name???
> I have tried many different things including:
> "CLIENT" & " " & "NAME"
> but to no avail.
> I know this must be something simple and I have consulted books and the
> help in VB. No luck. HELP ME!!!
> Jeremy Beginning VB programmer