open report

[fabiobarreto10]

friends,
I have a form with a textbox and a button that opens a report in accordance with the date placed in the text box. When I put the date 09.28.2012 the report opens with usually only records the date 28/09/2012.
When I put the date 01.10.2012 shows no record in the report, but there are records to date.
I'm not able to decipher why this happens.
I am sending a simple database with my doubt.
All help is welcome.
Thank you.

 

[Peter Reid]

What format is the date in the form? VBA expects is expecting mm/dd/yyyy and will only use dd/mm/yyyy if the former gives an invalid date

There are various ways to resolve this, one being to change the WhereCondition to;

"[Date_1]=#" & Format(get_date, "mm/dd/yyyy") & "#"

 

[fabiobarreto10]

Perfect Peter, managed to solve with your tip. Thank you.