ADVICE HOW TO SET UP?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I need some advice as to how to BEST set up this form. Ideally I would like
one form in Acess 2002 - to show multiple DIVISIONS- and within that
DIVISIONAL Section - show continuous records - the last record being blank
ready for input.

How would I do this? If I use multiple TABS - I can seem to figure out how
to get the tab form to show continuous records inputted for that division.

Help.. is this possible... ?
 
You need to create a continuous form and make it a subform. There are many
examples in the sample database that comes with Access.

Check out the Northwinds database and look at any of the forms. Almost all
of them work this way.

Pick a category, see the products. Pick a customer, see their invoices.
Pick an invoice, see the line items. Etc.

Rick B
 
Okay I sort of understand how to do this... but what is in my subform? What
table do I base the sub form on?
 
I would guess that your division would be on your main form. Your user
would select the division on that form. Then, there would be a subform just
below that that would dhow your continuous records. Your original post does
not make clear what data you would show in the "show continuous records -
the last record being blank ready for input."

You would need to share your table structure with us.

If I had to guess, I'd say you had something like...

Table1
DivisionNumber
DivisionName

Table2
DivisionNum
Date
Amount
Note

or something similar.

Your main form would have a drop-down combo box to select the division from.
Next to that combobox, you might display the name.

Your subform would be linked (Parent-Child) to the main form using the
Table1.DivisionNumber and Table2.DivisionNum. This subform would contain a
continous list of all the transactions in Table2 for the given Division.

I could be way off, but that is a typical application for form/subform with
continuous records in the subform related to the main form. Post more
details if this is way off.

Rick B
 
Back
Top