Home Forums Microsoft Access Microsoft Access Passing Criteria from a form to a Query in Access OCBD linked to SQL data RE: Passing Criteria from a form to a Query in Access OCBD linked to SQL data

  • Access automatically inserts the "#"s around a date (as long as the column you are setting your criterion off of is in date format). Because of this, you should only have to enter the date on the form (withouth the "#"s around it).

    If you want to manually force Access to read #s, you can use:

    "#" & [forms]![formname]![fieldname] & "#"