2-page form w/checklist

[Jim/Chris]

Why not have one from with 2 tabs
Header of the form would be employee name
I would also include a combo box for employee lookup
Tab 1 with a subfom containing employee Information
Tab 2 with a subfom containing Item information

Jim

-----Original Message-----
ok - I am sufficiently humbled! I have a main table/form

with employees and their basic information. I have a
"list" of 25 items needed for each employee. ( Leaving
"spreadsheetitis" and wanting a long thin table/form).
This is what I want to end up with: One form with the
employee info on it with a tab on top to see a second form
behind the first form which will show ALL of the 25 items
listed. Most of the items will be simply a Y/N field, but
5 of them will have a date field.

Right now I'm happy with the employee table and form. I

tried using a list box but realized it let's you pick "one"
item. I need all 25 items to show at a glance - and have
the ability to see what is not done - at a glance via the
checkmark in the Y/N box on the 2nd tab form. I'm
starting over with this second table - and getting advice
before jumping in again. Thank you ever so much - anyone.

 

[Guest]

Jim/Chris - gulp! Exactly - that is what I want. I dont know how to do it. I originally had a checklist table with all 25 items as fields. I've been advised that it's not good design and should have a table with 1-3 col's and use the "rows" for the identity of the checklist items. Then I got to trying to understand combo boxes and bound and unbound. Then I tried making a page break in my current form - got a sqiggly line - but didn't know how to proceed. When trying to access my 2nd table with the checklist items on it, I click field list, but get the employee field list and not the checklist field list. Am I hopless?

 

[Jim/Chris]

I hope I understand you. You want to see all 25 items
weather filled in or Yes/No for each employee
Two tables joined by primary key
TblMain
Employee information fields

TblItems
25 item fields

form SfEmp Info - to be used as a subform
Add all of the fields from TblMain including primary key

form SfItems to be used as second subform
Add all of the fields from TblItems including primary key

form Main
Add name of employee and primary key. This is where you
would add a combo box for looking up employees
Add 2 tabs to this form
Add subform and select SfEmp form to tab 1 and link to form
main by primary key
Add subform and select SfItems form to tab 2 and link to
form main by primary key

I hope this gets you started. let me know if you need any
more info

Jim

-----Original Message-----
Jim/Chris - gulp! Exactly - that is what I want. I dont

know how to do it. I originally had a checklist table with
all 25 items as fields. I've been advised that it's not
good design and should have a table with 1-3 col's and use
the "rows" for the identity of the checklist items. Then I
got to trying to understand combo boxes and bound and
unbound. Then I tried making a page break in my current
form - got a sqiggly line - but didn't know how to proceed.
When trying to access my 2nd table with the checklist
items on it, I click field list, but get the employee field
list and not the checklist field list. Am I hopless?

 

[Guest]

Jim/Chris - oh how I appreciate your help! Now, I have 3 tables and 3 forms for each table. Found I could break it up a bit into smaller parts. Here is were I am at.

Table1 - my main table with all employees info, name,add,phone, et
PK=CandID(autonumber) no dup

Table2 - the table with the list of all items required -Yes I want to see each item-my ck mark in Y/N will inform me if done
PK=CandID(number)no dup

Table3 - the table of certain admin tasks performe
PK=CandID (number)no dups

All 3 tables/forms also have a LastName field because I want Forms 2 and 3 to show the LastName as well as their own fields. I want to relate all 3 tables together the right way. I want Table 1 (form) to open. I want 2 tabs at the top to use. Tab 1 will show Table/or Form 2), Tab 2 will show Table/or Form 3).

I do not know how to bring into Form 1 - the 2nd form or the 3rd form. I've tried and I cant get field lists for anything except the form that I'm in (Form 1). Thank you again.
Niki

 

[Jim/Chris]

Put all the fields in table 1 in the main form in the form
header

Find the Toolbox toolbar and locate the icon that looks
like file folders. Click it. Draw the size of the tabe in
the Detail section of the form. You will notice two tabs
are created for you.

Click on the midd of the firs tab. find the
Subform/Subreport icon on the Toolbox toolbar and draw a
rectangle or whatever size you want. You will be broght to
a menu. Click on existing form and select the form you
created before(TbliItems). Click ok and then you will be
asked to either agree on the link the RecordIDname on the
Main form with the RecordId on the subform. click ok and
name the form and you are done.
Repeat for 2nd tab.

Later you can resize the subform and positions.

Jim

-----Original Message-----
Jim/Chris - oh how I appreciate your help! Now, I have 3

tables and 3 forms for each table. Found I could break it
up a bit into smaller parts. Here is were I am at.

Table1 - my main table with all employees info, name,add,phone, etc
PK=CandID(autonumber) no dups

Table2 - the table with the list of all items required

-Yes I want to see each item-my ck mark in Y/N will inform
me if done.

PK=CandID(number)no dups

Table3 - the table of certain admin tasks performed
PK=CandID (number)no dups.

All 3 tables/forms also have a LastName field because I

want Forms 2 and 3 to show the LastName as well as their
own fields. I want to relate all 3 tables together the
right way. I want Table 1 (form) to open. I want 2 tabs
at the top to use. Tab 1 will show Table/or Form 2), Tab 2
will show Table/or Form 3).

I do not know how to bring into Form 1 - the 2nd form or

the 3rd form. I've tried and I cant get field lists for
anything except the form that I'm in (Form 1). Thank you
again.