Hello this is my first post. I'm trying to have a subform that in on my main form switch record sources to display different data from a different station.
I have 10 different tables which have the same sturcture but different sets of data. I want to switch to what ever table via the Sub form when i select a different selection in the combo box (on the main form). This is my first time attempting a task like this in access so please be patient with me.