Autofill A Form?

[Angie]

I would love a little guidance here.
I am trying to create a subform that when opened shows all the fields that
need to be filled in. The two tables below are linkd to a QDAAssessment
table (by QDAID), so I need a new form for each assessment.
I have created two tables:
ScorecardKPA - This is the list of 66 areas to be scored for each assessment
Fields: WBS (Primary); Process; Mapping; Weight (this multiplied with the
Score field in "ScorecardScores" give me a final score)
ScorecardScores - This will store the scores
Fields: ScoreID(Primary) Score; QDAID(link to project table); WBSID
linked to ScorecardKPA

I need each process to prefill on a form, so I can input a 1 - 6 score.

From there it gets more complicated, but getting the darn form to autofill
is what I am having trouble with right now.

 

[UpRider]

Angie, it's been several hours now without a response. I think your request
is a bit confusing.
It's difficult for me to see the table relationships.
You mention a 'project table', but you don't describe it.
The ScorecardKPA table - is that 66 rows or 66 columns? (Important
question!!)
How are the tables related in terms of one-to-many, many-to-many, etc?
When you say you need a new 'form' for each assessment, do you mean new
'record'?

In general, you can often create your subforms independently to get them
looking like you want (complete with data)
before you insert them into the main form. The main form's job is to specify
a single QDAID for the subforms to use
when displaying their data.

UpRider

 

[Angie]

Thank you! I have re-written my request. I hope it helps.

I am trying to create a form that when opened shows all the fields that need
to be filled in. It needs to be based on the rows in a table I have named
“ScorecardKPAâ€, The data in “ScorecardKPA†is static and doesn’t change. It
is actually the criteria we score each assessment against. I have created a
table called “ScorecardScores†to save the actual scores in.

Each project has one assessment completed, so I need to create a FORM to
input the data and save the scores for each assessment.

I have created two tables for the scorecard:
ScorecardKPA - This is the list of 66 rows to be scored for each
assessment. They consist of the following fields (Columns).:
Fields: WBS (Primary); KPAProcess; Mapping; Weight (this multiplied with
the Score field in "ScorecardScores" give me a final score)
ScorecardScores - This will store the scores
Fields: ScoreID(Primary) Score; QDAID(link to project table); WBSID linked
to ScorecardKPA
Project Table – Has all Assessment information.

ScorecardKPA has a One to many relationship with ScorecardScores
ScorecardScores has a one to many relationship with the Project Table.
I need each process to prefill on a form, so I can input a 1 - 6 score.

 

[Angie]

I have an excel file showing what I am trying to re-create in access, I can
send if needed.

 

[UpRider]

Angie, download this 2002-03 format db at
http://www.dbtc.org/zipmdb/projectassessment.zip
It's 3 tables, 2 forms, 1 query that I hope can get you started for your
data input.

UpRider