M
Martin Edwards
Hi
After upgrading to Access 2007 (from 2003), I have a query that has stopped
working. It is something like
SECELT id
FROM [tbl names]
WHERE ([tbl names].firstname = [forms]![My form][firstname]);
It does not seem to register the value of the "firstname" textbox in the
form [My Form]. Accordign to the SQL profiler, the query just sends an empty
field "". Therefore instead of searching for a specific entry, I get all my
entries... The query seemed to work fine in Access 2002 and 2003.
When using
WHERE ([tbl names].firstname LIKE "*" & [forms]![My form][firstname] & "*");
the result is the same.
After upgrading to Access 2007 (from 2003), I have a query that has stopped
working. It is something like
SECELT id
FROM [tbl names]
WHERE ([tbl names].firstname = [forms]![My form][firstname]);
It does not seem to register the value of the "firstname" textbox in the
form [My Form]. Accordign to the SQL profiler, the query just sends an empty
field "". Therefore instead of searching for a specific entry, I get all my
entries... The query seemed to work fine in Access 2002 and 2003.
When using
WHERE ([tbl names].firstname LIKE "*" & [forms]![My form][firstname] & "*");
the result is the same.