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

  • January 31, 2012 at 2:04 pm

    #1440963

    SELECT dbo_ORDER.DATE_ENTERED

    FROM dbo_ORDER

    WHERE dbo_ORDER.DATE_ENTERED=[Forms]![Form1]![Text1].......set format of textbox to "general date"

    ..ps in Access remember to tab out of form text box before running query

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day