Data Base Design

[Bennadette Bell]

I have designed a relational data base with TABS on the
form to go to various input screens and then created sub
forms relevant to the individual table. What is the best
way to display the subform: In DATA SHEET view, SINGLE
FORM or CONTINUOUS FORM.
Is it best to have TABS to go to various SubForms or
should I design a new form and use a control instead to
load the form. (There seems to be some restriction with
using subforms in relation to layout,colours, background
etc)
Thanks in advance for any assistance

 

[Jeff Boyce]

Bennadette

I may not be following your description, but it sounded like you are trying
to show everything on a single form, using a Tab control.

It is more common practice to use a Tab control to show data from a single
table, plus related tables (in subforms on Tab pages).