Complicated form using option button

klar

Registered User.
Local time
Yesterday, 23:16
Joined
Jan 3, 2012
Messages
20
Dear Access experts,

I am new to forms but not to Access. Recently, I am not sure if Access is flexible enough to handle forms that uses multiple option buttons for entry. Attached is a form to key in performance of job candidates in a panel of interviewers.

The table data involved is Interviewer, Job candidate, Grade (Poor, Average, Good).

I know combo boxes will be simpler but I have been tasked to use option buttons instead. May I know if this can be done by Access?

Thank you very much.
 

Attachments

  • Difficult-form.jpg
    Difficult-form.jpg
    33.4 KB · Views: 98
Yes but your design is not properly normalized. What you have posted is a picture of a spreadsheet. Don't confuse the display of data with the actuall entry of it. In a relational database, you use reports to display data in the format you showed in your picture, but the entry is done differently. The interview results will be stored in a table separate from the table that stores the applicatent info.
tblApplicant:
ApplicantID
FirstName
LastName
etc.
tblReviewer:
ReviewerID
FirstName
LastName
etc.
tblReviewResults:
ApplicantID
ReviewerID
Result
etc.
The actual data in the review results table will look like:
JamesID, Reviewer1ID, 1
JamesID, Reviewer2ID, 1
JamesID, Reviewer3ID, 2
JohnID, Reviewer1ID, 3
JohnID, Reviewer2ID, 3
JonhID, Reviewr85ID, 3
Sharon......

You would use a main form that displays the applicant info and a subform with the reviewer results. The subform will have a combo to select the reviewer and the option group to choose 1,2, or 3.

You can then use a crosstab to produce a report that looks similar to the picture you posted.
 
Thank you very much for your reply. I am glad Access can handle the option buttons user interface entry.
 
Dear Access Gurus,

Some complication with the option button. The option button in the form needs to update two data items - ReviewerID and ReviewerResults. Unfortunately, Access only allows one data item to be bounded to a single control. How can I get an option button to update 2 data items at the same time? In other words, is it possible to have a control update 2 data items at the same time in a form?

Thank you for your patience.
 

Attachments

  • Difficult-form.jpg
    Difficult-form.jpg
    33.4 KB · Views: 86
I belive I mentioned in my earlier post that your design is not normalized. When you have more than one of something, you have "many". Please reread #2.
 

Users who are viewing this thread

Back
Top Bottom