If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Recordsouce question
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 |
Thread Tools | |
Display Modes | |
|
|