I have two tables with a one to many relationship. I would like to create a tab form where each tab is a different record from table 1 (a total of 8 records). I would like to be able to click on the tab for a particular record and then input the information from table 2.
Do you want the tabs to be dynamic? In other words, you have 8 records now, but if you add 2 more do you want two more tabs to be automatically added to the form? If so, I don't believe it is possible in Access.
Otherwise if table 1 is relatively static, then you can use a filtered subform on each tab to show the records related to the particular tab.