Multiple tables as record source in a form

[Guest]

I have a form with 5 tabs that I want to use as a data entry input form. How
do I incorporate different tables into this form. For instance, one tab
deals with types of boats and has a table while another tab on the same form
has information about the types of amenities at the marina and has its own
table. I do have the table joined in a relationship but I can only get one
table at a time and then I lose the data from the previous table.

 

[Rick Brandt]

I have a form with 5 tabs that I want to use as a data entry input
form. How do I incorporate different tables into this form. For
instance, one tab deals with types of boats and has a table while
another tab on the same form has information about the types of
amenities at the marina and has its own table. I do have the table
joined in a relationship but I can only get one table at a time and
then I lose the data from the previous table.

One table per form, even with a TabControl. Use subforms placed on the
TabPages.