[AccessD] Painted into a corner

John,

The Jet engine does not know about Access forms.  You need to assign
'[Forms]![PrintMenu]![txtStartDate]' to a variable and use the variable
in the SQL.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Tuesday 2003 Mar 11 15:10
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Painted into a corner

I decided to give this a try because you make it sound so simple. After
creating the query, I get an error, "The Microsoft Jet database engine
does not recognize '[Forms]![PrintMenu]![txtStartDate]' as a valid field
name or expression. (Error 3070)
<snipped rest of message from John>