Form is read-only

[adwanoy]

I have a continuous form based on a query that returns multi rows, I added a option group to be using the option group wizard [say "good', "satisfactory"], even though option group control source is one of the feilds but i cann't select the check box and I am getting the message Form is read-only, any body knows what is going on
thanks

 

[Remou]

Is it possible that your form is based on a qery that cannot be updated?

 

[TheAceMan1]

How are ya adwanoy . . .

Remember an [blue]Option Group[/blue] returns an numeric index value, not the checkbox captions!

Also, all data in the field bound to the [blue]Option Group[/blue] has to match the numeric indexes!

See Ya! . . . . . .

 

[adwanoy]

hi Remou and TheAceMan1
thanks guys. How do I know if the query cannot be updated.

 

[TheAceMan1]

adwanoy . . .

Have a look at the [blue]AddNew[/blue]

button, if it has that disabled look

then the recordset is uneditable!

See Ya! . . . . . .

 

[Pampers]

Hi adwanoy,
still struggling with the option group? If in your query more tables are used, the query has to meet certain criteria. Have a look at 'Create an update query' in Access Help.

Pampers
Just let it go...

 

[adwanoy]

AceMan, it is disable, that means the recordset is uneditable! as you said, can you pls tell me how to make it editable! or any other solution, anybody?

 

[Zed5010]

Hi adwanoy,

Check your primary key fields. Make sure all qry links are in order.

Zed

 

[TheAceMan1]

adwanoy . . .

Post the SQL of the query!

See Ya! . . . . . .

 

[adwanoy]

AceMan1
Q1 sql
------
SELECT Group.GroupID, Group.GroupName, Activity.ActivityID, Activity.ActivityName, ActivityTask.TaskID, Task.TaskDescription
FROM Task INNER JOIN (([Group] INNER JOIN Activity ON Group.GroupID=Activity.GroupID) INNER JOIN ActivityTask ON (Activity.GroupID=ActivityTask.GroupID) AND (Activity.ActivityID=ActivityTask.ActivityID) AND (Group.GroupID=ActivityTask.GroupID)) ON Task.TaskID=ActivityTask.TaskID;

q2 sql
------
SELECT Position.PositionID, Position.PositionName, PositionTask.TaskID, Task.TaskDescription
FROM Task INNER JOIN ([Position] INNER JOIN PositionTask ON Position.PositionID = PositionTask.PositionID) ON Task.TaskID = PositionTask.TaskID;

q3 sql
------
SELECT Task.TaskID, q1.GroupID, q1.GroupName, q1.ActivityID, q1.ActivityName, q1.TaskID AS q1_TaskID, q1.TaskDescription AS q1_TaskDescription, q2.PositionID, q2.PositionName, q2.TaskID AS q2_TaskID, q2.TaskDescription AS q2_TaskDescription
FROM (Task LEFT JOIN q2 ON Task.TaskID = q2.TaskID) LEFT JOIN q1 ON Task.TaskID = q1.TaskID;

q4 sql
------

SELECT q3.*, TaskCompetency.*, Competency.*
FROM Competency INNER JOIN (q3 INNER JOIN TaskCompetency ON q3.TaskID = TaskCompetency.TaskID) ON Competency.CompetencyID = TaskCompetency.CompetencyID;


---
and the form is based on q4, of course update query cant
't be a record source for a form. I still want to have each row as the folows

CompetencyID CompetencyDescription (from q4 upove)
----------------------------------------------------------
1 competency 1 execelent good satisfactory
2 competency 2 execelent good satisfactory
3 competency 3 execelent good satisfactory

and so forth
of course the is a check box in front of execelent good and satisfactory

 

[adwanoy]

can anybody help, with this problem that I can't solve

 

[TheAceMan1]

adwanoy . . .

Wow! . . . my mind is totally blown by that post of your resultant query! . . . (not trying to sound demeaning, just being truthful).

[blue]Your never gonna get an editable query out of that! . . . I promise! . . .[/blue]

So . . . where to start . . . hmmmmmmmmmmmmmmmm . . .
What you've posted points back to table structure! Gotta be something wrong here!

I'm sure you've been using this db for a while, so restructure is not exactly an invited guest! However this is the best advice I can can give at this time! . . . Ya know . .. if I close my eyes and try to see whats coming . . . its all trouble!

As an secondary shot at this, perhaps if you present your table structure and relate the results your after with the query you may get an viable answer. If you continue this,I'd suggest starting a new post, as it would be a good eye opener for a great many!

I wish I had better news! . . .

Your thoughts?

See Ya! . . . . . .

 

[Pampers]

Maybe you can put the option control in a (single) subform that is updatable

Pampers
Just let it go...

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

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