option button to control form query
One method is to put both queries in a union query and adding another field
for criteria from the Option Group.
Like this --
SELECT [Fcd] AS [Field1], [Ged] AS [Field2], [Mxy] AS [Field3]
FROM Table1
WHERE [Forms]![MyChoice]![Frame4] = 1
UNION ALL SELECT [Sam] AS [Field1], [Bill] AS [Field2], [Joe] AS [Field3]
FROM Table2
WHERE [Forms]![MyChoice]![Frame4] = 2;
--
Build a little, test a little.
"ehops" wrote:
Hello all-
I have two identical forms. They only differ by the select statement in
their queries. I would like eliminate one of the forms and use a radio
button in the footer to choose which query to use. Anyone have any
suggestions?
It seems pretty simple. I am somewhat new to Access.
Thanks for your help.
---ehops
|