[AccessD] Passing query "Between" date values into a form

Asger Blond ab-mi at post3.tele.dk
Sat Feb 12 13:14:58 CST 2011


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





More information about the AccessD mailing list