I am trying to open a record for editting. Whe I do I get the following error:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft OLE DB Provider for ODBC Drivers

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

It seems as though I have the columns correctly place and idnerified, yet I
keep getting this err. I have blank fields because they are n.

Would any know anythinf about this?

If the blank fields are text, make sure you surround them in apostrophies.

If they're numeric, precede them with a zero.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------Â*-----------------------
|\----------------------------Â*-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------Â*-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------Â*-----------------------
*-----------------------------Â*-----------------------

"Rob" wrote:

> I am trying to open a record for editting. Whe I do I get the following error:
>
> Database Results Error
> Description: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in
> criteria expression.
> Number: -2147217913 (0x80040E07)
> Source: Microsoft OLE DB Provider for ODBC Drivers
>
> One or more form fields were empty. You should provide default values for
> all form fields that are used in the query.
>
> It seems as though I have the columns correctly place and idnerified, yet I
> keep getting this err. I have blank fields because they are n.
>
> Would any know anythinf about this?
>