Article ID: 170699
Article Last Modified on 1/20/2007
APPLIES TO
- Microsoft Access 97 Standard Edition
This article was previously published under Q170699
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
You are not prompted to enter a parameter value when you output a form to
text if the form is bound to a query that contains an invalid form control
reference on its Criteria row. However, the text file that is created does
not contain any data.
CAUSE
This behavior occurs if you use implicit form control referencing in the
query. For example:
Forms![FormName]![ControlName]
RESOLUTION
To ensure that the text file that is created contains data, use explicit
form control referencing in your query, or use the control's Value
property. For example:
Forms![FormName].[ControlName]
-or-
Forms![FormName]![Controlname].Value
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.
Keywords: kbbug kbusage KB170699