Hello,
I’ll give you the scenario of my problem first. I have a view with more than 20 editable columns. Since I have a column that should have its value based on the list on the dialog box, I’ve customize a bit my InViewEdit. If I click the editable column one by one to edit them I encounter no problem. But if I used the tab key to enter the editable column, there’s the problem goes, since using the tab key will make the colprogname parameter array in SAVE_REQUEST option. To have a more clear picture of my problem here’s the code of my InViewEdit
Select Case Requesttype
Case QUERY_REQUEST
If ColProgname(0) = “Cities” Then
city ( 0 ) = "New York City"
city ( 1 ) = "London"
city ( 2 ) = "Paris"
var = workspace.Prompt ( PROMPT_OKCANCELLIST, "" , "Please select a city" , "" , city )
If Datatype ( var ) = 8 Then
doc.replaceItemValue ( "City", var )
Call doc.Save ( True, True )
End If
continue = false
Exit Sub
End if
Case VALIDATE_REQUEST
Case SAVE_REQUEST
For i = 0 To Ubound(Colprogname) Step 1
Call doc.ReplaceItemValue(Colprogname(i), Columnvalue(i))
Next
Call doc.Save(True, True)
End Select
The problem when I used tab is on the Case QUERY_REQUEST the line continue = false. Since I used tab key, the Colprogname and ColumnValues are now array, and since I disrupt the process, the Error Message “Operation stopped at your request” is now prompting. As I said earlier if I clicked the column one by one to edit, there will be no problem. Now, is there some one out there how to deal with my problem which is to eliminate the prompting error message. Thanks