Gowey Mike W
Mike.W.Gowey at doc.state.or.us
Tue Feb 14 16:14:43 CST 2006
Unfortunately that gives the same error :-( -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Tuesday, February 14, 2006 2:56 PM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com