Asger Blond
ab-mi at post3.tele.dk
Sun Feb 13 17:21:59 CST 2011
Was this response of any help to you? Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Asger Blond Sendt: 12. februar 2011 20:15 Til: 'Access Developers discussion and problem solving' Emne: Re: [AccessD] Passing query "Between" date values into a form In your query add two named columns to the grid Start: [Date from:] End: [Date to:] Then in your form add a textbox with ControlSource: =[Start] & " " & [End] Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Kostas Konstantinidis Sendt: 12. februar 2011 15:30 Til: AccessD at databaseadvisors.com Emne: [AccessD] Passing query "Between" date values into a form Hi all, The form I built is based on a query, and in that query I use the simple "Between [Date from:] And [Date to:]". What I want to do is to pass the values of the two parameters into a textbox in the heading of the form so if the dates parameters are e.g. 01/01/2011 and 31/01/2011 , to be displayed them in the form.. I try ControlSource: =[Date from:] & “ “ &[Date to:] It works in a report but not in the form Many thank’s /kostas -- 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