(Solved) – Getting syntax error on if statement with trying to get a msbox to work in ms-access

  • by
(solved)-–-getting-syntax-error-on-if-statement-with-trying-to-get-a-msbox-to-work-in-ms-access

Trying to check to make sure all records are completed before allowing the record to be turned off from further editing. I keep getting a compile error expected end of statement. I thought I followed proper syntax however I’m missing something.

If MsgBox("Are you the last crewmemeber to input your hours?", vbYesNo   vbQuestion) = vbYes then me.butCompleteFlight.Value = True Else me.butCompleteFlight.Value = False end if

Leave a Reply

Your email address will not be published. Required fields are marked *