Unanswered: syntax for where criteria in the openform method
What is the correct syntax for where criteria in the openform method?
I would like to compare the shipped date in the form based on a table with the input date. The error occurred in the syntax in input date because I tested with an actual date and is working.
I tried various ways but still can't figure out what is the syntax for the date.
I'm using Access 2000 as FE and SQL Server 7.0 as BE.
This is what I have
DoCmd.OpenForm "shipment_hist_list", , , "[shipped_date] ='& # bdt # &'"