It works so far that when case = fixed the field is not readonly, in the other cases it is.
But when the state is fixed I want it to load the other list.
Bug_Fields("BG_STATUS").List = Lists("Bug Status2")
but all I see is Fixed in the field. Not a drop down with the new list options.
In the grid, you can see the dropdown list only when the field has the focus. You can see it at all times in a detail view (double-click the defect line).
As a general rule : if your code does not produce the results that you expect, remove or comment out the "On Error Resume Next" statement that's normally at the beginning of each of your subs/functions. This will bring a message window if there is an error. Alternatively, leave that statement as is and add the following statement at the end of each sub/function :
If Err <> 0 Then MsgBox "Error in function " & "<<< insert here your function name >>>" & vbCrLf & Err.Description