simplifying a form

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I was just informed by the SVP that the database he was
having me look at doing had to be very simple to use and
to enter info into. There will only be 6 tables to hold
the info. To make it simple I thought about using a tab
control on one form with each tab as the table info. The
whole thing would start out being unbound. Is it possible
to make 6 tabs on the tab control one for each table of
info? If so, how and were would I place a query to show
the info? Also, I am placing a combobox on the form to
show the clients names and when selected fill a listbox.
I would then like to be able to select an item from the
listbox and have all the tabs go to that record. Is this
possible? I have done it before but not with multiple
tables like I mentioned above. I am asking now before I
get to far along and begin pulling what's left of my hair
out.
Thanks for any assistance.
*** John
 
You can place a Subform control on each page of a Tab control, and embed a
Form in each. But, you don't always have to have a Form for each Table...
Forms can be based on Queries.

And, just for your information, I was excited about the potential ease for
users of using Tabs when that control was first introduced. With permission
from my client, I did not charge for the extra development time, and created
a modest application that used the Tab control as the primary navigation. It
did take extra time and effort, and the feedback from the users was that
they liked it no better, perhaps not as well, as the more conventional form
navigation in other Access applications.

So, that may not be as beneficial as it appears on first glance.

Tab controls are good for things like "property sheets" but not necessarily
for application navigation.

I also don't understand "whole thing start out being unbound". In my
experience, it is much easier to learn the way Access works and use bound
forms for all data entry and manipulation tasks. I use unbound forms for
switchboards, certain image displays, and report/form selection tasks, and
rarely for anything else.

Larry Linson
Microsoft Access MVP
 
Back
Top