Access stores dates as the number of days since 12/31/1899. So todays date is stored as 44692.
Jet/Ace uses the U.S. date format regardless of what format your computer is set to in your regional settings.
Therefore to get accurate results you need to convert your international dates to a format that jet/ace uses.
Code:
Const conJetDate = "\#mm\/dd\/yyyy\#"
Format(Me.txtdatefrom, conJetDate)
Added bonus to the above is that it delimits your dates with octothorpes so access knows it is a date datatype.