Access SQL Wildcard in WHERE statement.

By mandw ·
I have an Access SQL statement (Using Access 2000)that contains the line:

WHERE ((([tblResupplyOrder Numbers].[Our Order Number])=[Forms]![frmEditOrder]![Combo51])

This query is used to populate a report, but being conditional it only works when I drive it from form [frmEditOrder].

I want to wildcard [frmEditOrder] so that any form with a Combo51 can drive the query and the report.

Otherwise I have to replicate the query and report with a new form name for each one.

Thanks in advance for any help.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums