I think you need to be a little more specific. Do you want to return different data on the same form? You could do this by using two queries as opposed to switching tables? I don't even know if you could switch tables or control sources on a form like that.
Give a little more detail