Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    6

    Unanswered: Switch Record source of Subform

    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.

    Table name:
    Newyork
    oklahoma
    Seattle

    Form:
    Loaction Choice


    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    normalise your data and the problem you are experiencing disappears
    when ever you see a tabel structure such as
    Newyork
    oklahoma
    Seattle
    itrs a sure sign of a suspect design.

    unless there is some specific attribute that is different in each of those tables then they should be in one table with a FK pointing to another table, called say 'Cities'

    Fundamentals of Relational Database Design -- r937.com
    The Relational Data Model, Normalisation and effective Database Design
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •