G
Guest
Hello,
I ahve one form that has a command button on it.
On its click event, the following code will run:
----------
Private Sub Submit_Click()
Dim tabella As String
Select Case instruments
Case Is = 1
tabella = "tblobs"
Case Is = 2
tabella = "tblmoods"
Case Is = 3
tabella = "tblabs"
Case Is = 4
tabella = "tblpas"
Case Is = 5
tabella = "tblshy"
End Select
Dim riporta As String
riporta = Combo37.Value & Combo37.Column(4) & strumento
DoCmd.RunSQL ("INSERT INTO " & tabella & " (strpazID,COMPLETO) VALUES('" &
Text44.Value & "',0)")
DoCmd.RunSQL ("UPDATE " & tabella & " INNER JOIN TBLPAZIENTI ON
TBLPAZIENTI.strID=" & tabella & ".strpazID SET " & tabella &
".STRNOME=TBLPAZIENTI.STRNOME WHERE strpazID='" & Text44.Value & "'")
DoCmd.RunSQL ("UPDATE " & tabella & " INNER JOIN TBLPAZIENTI ON
TBLPAZIENTI.strID=" & tabella & ".strpazID SET " & tabella &
".STRCOGNOME=TBLPAZIENTI.STRCOGNOME WHERE strpazID='" & Text44.Value & "'")
DoCmd.OpenForm "frmQuestionario", acNormal, , , , acWindowNormal, riporta
DoCmd.Close acForm, Me.Name, acSaveNo
End Sub
----------
The last line of this code should close this form (which is modal, btw),
while the line immediatly before will open a new form.
Anytime I click the button, Access will close dramatically, asking if I wnat
my db repaored and re-opened.
Why this would happen?
I have checked the code and it works fine. I have tried to set modal=No and
the error will raise anyway.
Why?
I ahve one form that has a command button on it.
On its click event, the following code will run:
----------
Private Sub Submit_Click()
Dim tabella As String
Select Case instruments
Case Is = 1
tabella = "tblobs"
Case Is = 2
tabella = "tblmoods"
Case Is = 3
tabella = "tblabs"
Case Is = 4
tabella = "tblpas"
Case Is = 5
tabella = "tblshy"
End Select
Dim riporta As String
riporta = Combo37.Value & Combo37.Column(4) & strumento
DoCmd.RunSQL ("INSERT INTO " & tabella & " (strpazID,COMPLETO) VALUES('" &
Text44.Value & "',0)")
DoCmd.RunSQL ("UPDATE " & tabella & " INNER JOIN TBLPAZIENTI ON
TBLPAZIENTI.strID=" & tabella & ".strpazID SET " & tabella &
".STRNOME=TBLPAZIENTI.STRNOME WHERE strpazID='" & Text44.Value & "'")
DoCmd.RunSQL ("UPDATE " & tabella & " INNER JOIN TBLPAZIENTI ON
TBLPAZIENTI.strID=" & tabella & ".strpazID SET " & tabella &
".STRCOGNOME=TBLPAZIENTI.STRCOGNOME WHERE strpazID='" & Text44.Value & "'")
DoCmd.OpenForm "frmQuestionario", acNormal, , , , acWindowNormal, riporta
DoCmd.Close acForm, Me.Name, acSaveNo
End Sub
----------
The last line of this code should close this form (which is modal, btw),
while the line immediatly before will open a new form.
Anytime I click the button, Access will close dramatically, asking if I wnat
my db repaored and re-opened.
Why this would happen?
I have checked the code and it works fine. I have tried to set modal=No and
the error will raise anyway.
Why?