Im using a pice of code that should read a cost from a table I ahve created. The cose is
Private Sub Cost_Click()
If Period = "Morning" Then
Cost = table!Cost[Morning]
ElseIf Period = "Afternoon" Then
Cost = table!Cost[Afternoon]
ElseIf Period = "Evening" Then
Cost = table!Cost[Evening]
ElseIf Period = "Evening" And Extension = "Yes" Then
Cost = table!Cost[Evening Extension] else
Cost = table!Cost[Special]
End If
End Sub
What is wrong with it, it is expecting for an end of statement after each line where I have used Cost=
Enter your message below
Sign in or Join us (it's free).