If Statement

[jeffsal]

I keep getting "Ilegal use of . ! or (" with the following code and can not figure it out:

If IsNull(Me.List32.Value) Then
MsgBox (" Hey!!! You forgot to Select a Report")
If Me.Text58.Value = "lvs" Then
Me.staff = "lvs"
ElseIf Me.Text58.Value = "kps" Then
Me.staff = "kps"
Else
stDocName = List32.Value
DoCmd.OpenReport stDocName, acPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdZoom100
DoCmd.Close acForm, "App"
End If

Thanks

 

[PHV]

Again (as in thread702-1356014) you have a coding error:
[!]Else[/!]If Me.Text58.Value = "lvs" Then

Furthermore, which line of code is highlighted when the error raises ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jeffsal]

I fixed that and still get the error. No line of code is highlighted. Thanks

 

[PHV]

No line of code is highlighted
Even when in Debug mode ?


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya jeffsal . . .

Perhaps:

[blue]   stDocName = List32.Value
[purple][b]should be:[/b][/purple]
   stDocName = Me.List32.Value[/blue]

See Ya! . . . . . .