How do I make option group for a continuous form

[adwanoy]

I have a form and a subform, the Subform returns multi rows
each row is a actually a competency needs to be evaluated "excelent", "good", "satisfactory" I added a option group check box to be displayed next to the row to let the user check one. I am facing a problem that when I check one all the rows are checked, where I need to do each row alone.
any help will be appriciated

 

[PHV]

Standard behaviour for unbound control in the detail section of a continuous form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[adwanoy]

Thanks, But how can I impliment that.

 

[Pampers]

That means that you have to set a control source for your option control (instead of being unbound), for example a Field in your table or query. Otherwise the different options checked for differenct records can not be stored...

Pampers
Just let it go...

 

[adwanoy]

I appreciate your reply, but please bare with me, I am not that good in Access, what I have in the table is a field that will hold a "1 or 2 or 3" depending on what the user checks "1-excelent","2-good","3-satisfactory" and as I said I might have 50 rows wher each one gets a different value.
thanks

 

[MajP]

Sounds like in your case you added the group, but did not set the control source of the option group to your field. Check the control source property.

 

[adwanoy]

Thanks MajP
it is true, but I didn't get it. the rows that are displayed are from a query, and the value of the option group will be stored in a anothor table "Performance Evaluation". where as the query is built on others tables "groups, tasks and competencies". basicaly, I pull out all the competencies for an individual depending on the "group and the task he/she works" then I added the option group next to each competency, once the the option group is checked, I want to store that value in "Performance Evaluation" table. so which feild should it be for control source
thanks

 

[MajP]

You will probably need to explain your tables and how they are related. How are people, groups, tasks, and competency related. Describe what is on the main form and how it links to the subform. I think you might need another table (a linking table), because I think you have a many-to-many join.

 

[adwanoy]

MajP
Okay, here are the tables
Group
----
GroupId--PK
GroupName

Activity
--------
GroupId---PK&FK
ActivityId--PK
ActivityName

ActivityTask --link table
------------
GroupId--PK
ActivityId--PK
TaskId--PK

Task
-----
TaskId--PK
TaskName

TaskCompetency--link table
--------------
TaskId--PK
CompetencyId--PK

Competency
----------
CompetencyId--PK
CompetencyName

and of course I have table
Performance Evaluation
----------------------
EvalId--PK
--
--
PerformanceEvaluationCode
--this is where the "check" whould be saved


the main form

feilds and controls about the "evaluatee employee" and then, the user picks a group from a combo box, then an activity from another combo box. depending on those the subform is displayed which source is a query has two varialbles groupid and activityid.
the query reurns the competencies depending on the relations above.

 

[MajP]

In the Performance Evaluation table there seems to me that you need some foriegn keys. I would think you need in that table

Performance Evaluation
EvalID - PK
EmployeeID - FK
CompetencyID - FK
evalCode -

To do what you want requires some coding and it can be done several ways, but basically once you choose the competencies for a person to evaluate you need to add records to the above table. So if employee 1 has three competencies (7,8,9) some how you need to get in the above table

employeeID CompetencyID
1 7
1 8
1 9

If all employees get evaled on all competencies then you could use an append query to populate the table every time you add a new employee.

 

[adwanoy]

you are right I do have that, actualy it is
Performance Evaluation
----------------------
EvalId--PK
empId--FK
groupid
activityid
PerformanceEvaluationCode
and others

once employee is evaluated I only need the overall performance evaluation(which is an average of all the competencies evaluation), the way we keep individual competencies evaluation is hard copy, I know the next step is to program that.
again thanks for your reply, but you haven't gave me the solution to my problem.
and if I may, I am facing another problem which is the query that subform is built on, has 2 criteria for the 2 comboboxes group and activity, as [forms]![form1]![cobogroup] and [forms]![form1]![cobogroup] for group id and activityid respectfully. but it only works with one, not two

 

[MajP]

Alright, I think I see what you are doing. In your Competency table add a "place holder" field call it "intCompEvaluation". Includes this on your subform and bind the combo box to it. You could put a "Sum of" text box at the footer of the subform. Now on some event, (form before update, or maybe a cmd button click) push the value of this textbox along with other keys into your Performance Evaluation table. On the on current event clear out the values of the "intCompEvaluation

 

[adwanoy]

I am sorry but my problem at the very begining is to add a option group that has 3 values next to each row of competency where the user can check one, without ms access changes the rest of the rows

 

[Pampers]

Hi adwanoy,
I also created a option group for every row, with the values bad, good, excellent. If I create this group, the wizard asks in which field I want to store the value. Here you have to choose for a particular field - remember the value for later will not work here. Try to recreate the option box with the wizard.


Pampers
Just let it go...

 

[MajP]

Like I said, you need to bound this control to a "dummy field" in your table. If it is not bound it is just not going to work. I use this technique often to make a many to many form. For example lets say I am making a form where people can choose from a set menu. In the menu table I put a boolean selected field "blnSelected". Then I make a main form with people and the subform with the menu items. I click in blnSelected field and then in the before update event I write to the join table, "joinTblPerson_MenuItems", a person ID and Menu item ID for each item checked. Then on the on current event I load blnSelectedField based on the values in the "joinTblPerson_MenuItems".