C
Chris v.
I've written two queries (returning different results using the same fields)
that can use the same form to display the data. I would like the end-user to
select a different command button, which would set the Record Source Property
of the form to the correct macro, so I can use only 1 form, having the 2
command buttons on the Switchboard. I don't seem to get the syntax in the
Expression Builder correct.
Is what I want to do not possible, or is it not a good way to do what I
want, or can someone show me an example of the correct syntax? For the
"Expression" in the Expression Builder I've tried various permutations of
[queries]![queryName] without luck.
Thanks, in advance.
Chris v.
that can use the same form to display the data. I would like the end-user to
select a different command button, which would set the Record Source Property
of the form to the correct macro, so I can use only 1 form, having the 2
command buttons on the Switchboard. I don't seem to get the syntax in the
Expression Builder correct.
Is what I want to do not possible, or is it not a good way to do what I
want, or can someone show me an example of the correct syntax? For the
"Expression" in the Expression Builder I've tried various permutations of
[queries]![queryName] without luck.
Thanks, in advance.
Chris v.