Have the default value in a textbox on a form, and then the user can change it if it's not what they want. In the query, reference the textbox in the Criteria line like this:
[Forms]![frmThisForm]![txtYear] The txtYear textbox would probably be unbound, with the Properties default value set to Year(Date) to show the current year. Tobi -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of eliotchs Sent: Monday, December 05, 2005 10:16 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] ? on Parametr query with a default value ?? Hi, Does anyone know if it's possible to create a parameter query with a default value. Example: I have a parameter asking for a year from a date field, I would liek to have current year as a default. Thanks Joe ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/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/
