Reference to a public constant in query criteria filed
- Thread starter camilovic
- Start date
camilovic,
The only ways that I've seen it done are:
=Forms![SomeForm]![SomeField]
Must be on an open form.
or
=FunctionCall()
Where the function is in a public module and merely returns
the value of the constant.
We'll see what everyone else comes up with.
Wayne
The only ways that I've seen it done are:
=Forms![SomeForm]![SomeField]
Must be on an open form.
or
=FunctionCall()
Where the function is in a public module and merely returns
the value of the constant.
We'll see what everyone else comes up with.
Wayne
RichMorrison
Registered User.
- Local time
- Today, 14:14
- Joined
- Apr 24, 2002
- Messages
- 588
Agree with Wayne's reply.
Make a module with functions to "read" and "write" parameter variables. This is much better than using the name of an open Form.
RichM
Make a module with functions to "read" and "write" parameter variables. This is much better than using the name of an open Form.
RichM
