PhilOfWalton
I had thought about placing he subform 121 directly on the main form (100) pulling the other demographics to the main form as well - I have a somewhat similar form to the one you have created that I use for some things in the lab; however, the topic is about tab-controls so that was my starting point.
The ComboBox is a nice addition for the people search and is something I use very often for such tasks.
However, looking at the form that OP
posted #11 it looked like he has a lot of information to present (don't really know) so a tab-control might be reasonable to group related data.
OP has provided very little in the way of how the database is constructed.
ijared
Hi , On the Sub-Forms I have attached to the form, should I the table with all the fields?
This depends on your database design.
A query may be enough to pass the data through; however, your question leads me to suspect that you do not understand the database design.
Perhaps you should look a the form PhilOfWalton appended to the database in his post.