[AccessD] Criteria Question

You can try wrapping the criteria line in a Cbool() function to
translate the "yes" or "no" to a boolean.  Otherwise, anything you type
in is a string, which won't compare to a yes/no.

Cbool([Enter Yes or No])

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W
Sent: Tuesday, February 14, 2006 1:35 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Criteria Question


 

Within my table I have a field that is set to Yes/No format.  I am
attempting to create a query that prompts the user to enter Yes or No as
a criteria for this field.  Everytime I prompt the user and they enter
Yes or No in the prompt box, they get an error of

"This expression is typed incorrectly, or is to complex to be
evaluated."

But yet if I type in Yes or No in the actual query criteria it works
just fine.  I just get this error when I prompt the user to enter the
criteria.

Anybody have any ideas?

TIA,

Mike
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com