Re: Macro Open Form Where Clause

Tech-Archive recommends: Fix windows errors by optimizing your registry

JJF,

I have no experience of being able to just type a value, without the field it qualifies, into the Where Condition argument of a macro. I am surprised to learn that the form opens at the desired record with just the date entered. Normally I would expect to see something like this for the Where argument:
[NameOfYourDateField]=#06/01/2007#

--
Steve Schapel, Microsoft Access MVP

JJF wrote:
A Macro opens a Form which is based on a Crosstab Query which shows the occupied seats in my theater. If I type #06/01/2007# into the Where box of the Macro it works perfect but if I use another Form with a Calendar to generate the date the "Jet engine doesn't find a valid field". I only get this message when the Form is based on this Crosstab Query. My calendar Form works fine opening all my other Queries, Forms and Macros. Any suggestions?
.