Why does this code not work?

[jaad]

I have a report where two controls should be dependent of the [moveINOUT] control on the same report.

Private Sub Report_Current()
    If MoveINOUT = "IN" Then
    NoteOUT.Visible = False
    RepairOUT.Visible = False
    
    Else
    
    If MoveINOUT = "OUT" Then
    NoteOUT.Visible = True
    RepairOUT.Visible = True
    
    End If
    End If
    
End Sub

I've tried a variation of ways and I don't get it, this code above should work???
any ideas? thanks

[mshmyob]

Why do you have a nested if statement.

If your only two posiible values for MoveINOUT are "IN" or "OUT" then you just need the following:

[code=vb]

If MoveINOUT = "IN" Then
NoteOUT.Visible = False
RepairOUT.Visib le = False
Else
NoteOUT.Visible = True
RepairOUT.Visib le = True
End If
[/code]

Keep in mind you did not mention what was "NOT WORKING".

cheers,

[TheSmileyCoder]

A report has no "Current Event" (unless it was added in 2007 which I wouldn't know).

Use Detail_Format or Detail_Print.

[jaad]

Yes it is Access 2007 and yup, it does have an "On current"

[TheSmileyCoder]

Well try using detail_Format and see if that doesnt do it for you :)

[jaad]

That doesn't work No.

[mshmyob]

You still have not told us what is happening (ie: what is the error)

Is any part of the if statement triggering?

Where are the variables and how is the INOUT variable populated?

Have you changed the code like I suggested?

Important: What view are you opening the report in??? To get the Report.Current event to trigger the report must be run in Print Preview or Normal mode.

etc.

cheers,