error message

kingsgambit

Registered User.
Local time
Today, 23:42
Joined
May 27, 2001
Messages
134
When i run this code, if the checkbox is not ticked it works. Either the Jobcard is complete and it shows the report or it goes to the control. But if you go to the control then tick it, then press yes for complete nothing happens can you help.

If Me.completed.Value = 0 Then


If MsgBox("Is this a Completed Job Card?", vbYesNo) = vbNo Then
DoCmd.GoToControl "completed"

Else
DoCmd.SetWarnings True


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Dim stDocName As String

stDocName = "jobcardinvoice2"
DoCmd.OpenReport stDocName, acPreview
 

Users who are viewing this thread

Back
Top Bottom