Can I change the recordsource of a form on the fly? In other words, I have
one table (a small one-to-one so I didn't split it) and I would like to have
3 maybe 4 queries off that one table. Then change the recordsouce of the form
to query1, or query 2, etc, depending on what the user picks in a combo. The
fields displayed on the form from each query would be the same. I know I
might be able to do it with case statements, but is there an easier way?
Thanks a bunch!!!
--
Milton Purdy
ACCESS
State of Arkansas