[oMADMANo]

okay so I have a form called "Membership" and a tick box "Riskassesment" using the control source "Riskassesment" from the table "Membership Database" set up to a yes/no option. Im attempting to have my code only change the current record and display the text boxes and buttons I have made
called "Risk" (label) , "Risk1" (label) , " Risktext" (text box) , "Risk1text" (text box) , "RiskButton" (button).

This is an example of the code I am trying to use

Private Sub RiskAssesment_AfterUpdate()

 Set db = CurrentDb
 Set rs = db.OpenRecordset("Membership Database", dbOpenDynaset)
    
   
   
   If vbFalse(rs![RiskAssesment]) Then
     Me.Risk.Visible = False
       
   ElseIf vbTrue(rs![RiskAssesment]) Then
     Me.Risk.Visible = True
    
   End If

End Sub

but I get the error "expected array"

I have tried

If me.RiskAssesment = False Then

me.Risk.Visible = False

ElseIf me.RiskAssesment = True Then

me.Risk.Visible = True

but it updates all records.
Please help me fix this.

[June7]

Try simply:

Me.Risk.Visible = Me.RiskAssessment

vbFalse and vbTrue are not functions, they are constants.

So expression could be:
If Me.RiskAssessment = vbFalse

This post has been edited by June7: 02 February 2012 - 01:50 PM

[tlhIn`toq]

Quote

tick box "Riskassesment"

If me.RiskAssesment = False Then

If you mean "checkbox"... A checkbox cannot be true or false. Its a GUI object. Whether or not it is checked can be true or false however.

You're checking if the control is false, not if the .Checked property is.

[oMADMANo]

SOLVED ! thanks