Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Making a scoring form

Making a scoring form

Making a scoring form

In a scoring form I have two combos,
- Category, which has a list of all categories that companies have entered
- Company, which gives the companies in the selected category

For each category there are a number of judges who score the company against 7 criteria.

The scoring subform shows the selected Category and Company and allows entry of the scores. The form's query source has fields Category, Company, Judge, Score 1, Score 2, Score 3, Score 4, Score 5, Score 6, Score 7, with criteria for the Category/Company in the main form.

In using the form I pick a Category, it shows me the Companies so I can select one. The subform allows entry of scores for the first Judge; then I use the record navigator to move to the page for the next judge and enter the new scores.

All works fine.

To improve the user interface I'd like
- after entering Score 7, to advance to the next record, ie next judge if any remain in this category
- after the last judge don't show a new blank form with no judge name but move focus to the Category combo and wait for the next Category/Company selection.

RE: Making a scoring form

Are the scores separate fields or separate records. Hopefully records. Can you describe the recordsource of the subform.
If it is records the "oncurrent" event happens for each record and the recordcount property tells you how many records

So I think you want to check the recordcount in the on current event and then move to the next record on the main. If the recordcount equals the number of judges (use a dlookup to determine number of judges) then set the allow additions to false. move focus to the combo. Do your selections. Move to next record and do the count again to see if the number of subform records is less than the number of judges. If so set allow additions to true.

Just guessing, there is not enough detail here to provide more.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close