For the source for the textbox, use this: =iif([DateField]>[txtEndDate],"Not Eligible",[DateField])
The EndDate textbox can be set with Visible=False if you don't want it seen. Be sure that you rename the DateField textbox, something like txtDateField, or you'll get an error instead of a value. Hope you can get home soon, soldier! Tobi -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mbowshier2002 Sent: Thursday, October 27, 2005 3:10 AM To: [email protected] Subject: [AccessDevelopers] form's Greetings from Iraq, The problem i have is this: I have created a form that pulls data from a query, i am trying to write a validation rule. for example if the date is greater than 11-Dec-05 then i want it to say "Not Eligible" I know this is simple can someone please help a solider out? thanks mike Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
