View Single Post
  #2  
Old November 5th, 2009, 10:01 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default 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