basing a form on a RWOP query

[TechBoy]

Re:Access 2002

If I base my form on an RWOP query, can I dynamically select from an
RWOP query result set to display on the form? Does someone have an
example?

Thanks.

[Larry Linson]

"TechBoy" wrote

If I base my form on an RWOP query,
can I dynamically select from an
RWOP query result set to display on
the form? Does someone have an
example?

Hunh? What does "dynamically select from an RWOP query result set to display
on the form" mean to you? You use it as you would any other bound form. If
you mean can you "filter" the records to be displayed -- yes. If you mean
can you base another Query or SQL on the RWOP Query -- yes. If you mean yet
something different, you'll need to clarify.

If you mean that "on this instance of the form, can I display Client Name in
Text Box Who, and in another instance, can I display Client Company", the
answer would be yes, with some VBA code.

Larry Linson
Microsoft Access MVP