By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,983 Members | 2,035 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,983 IT Pros & Developers. It's quick & easy.

Access 2003 - Find function on SELECT row source

P: n/a
Running Access 2003 with a database in 2000 file format and noticed
that the search results differ depending on what version of Access is
in use. Users running Access 2000 are able to call the find function
to search for a record in a field that displays a location but is
populated by a location code. When the user enters the location code,
the search will return a record with matching location. Running the
same database in Access 2003 and conducting the search will not
succeed unless the user enters the exact spelling of the location!
The row source type is set as Table/Query and the Row Source code
follows:

SELECT [TZS - GIC].TZS, [TZS - GIC].Location FROM [TZS - GIC] WHERE
TZS = GIC ORDER BY [TZS-GIC].Location;

The bound column is 1, which is the TZS field and the column count =
2.

What is the difference in Access 2003 that is causing this?

Thanks.
msemo

May 15 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.