Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3

    Unanswered: One form to enter all data in mutiple tables

    Hello I would like to create a form, that be used to enter data into multiple different tables. I would like to use tabs for each different table. Can this be done? Thanks in advance.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    One way would be to create a Form for each Table, then place one Subform, based on each of these Forms, on a different Page of the Tabbed Control.

    There may very well be other approaches, but you've given us almost no information on what you're trying to do, here, what relationships you have between Tables and so forth.

    If you have, for instance, a One-to-Many Relationship between Tables, you might do better using a Main Form/Subform scenario, with the 'One' side displayed on the Main Form and the 'Many' side displayed in the Subform.

    More details on your part will allow us to offer you more/better options.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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