Fast Love. I mean Help. (Solved)

[Bazzlad]

Right, I'll set the scene.
Coding a Access Database. Using VBA.

The question:
On a form, how can I make an IF statement record specific, instead of form specific?

EG

Private Sub Contacted_Owner_Click()
If Contacted_Owner.Value = no Then
Repair_Agreed.Visible = False
Combo17.SetFocus
Else

Repair_Agreed.Visible = True
Command39.Visible = False
Label40.Visible = False

End If

End Sub

Works. Until I scan through the records. When I do that it keeps the FIRST records value.

Quick help would be good
I know I'm missing something REALLY simple.....
Bazz

[Ephesians]

If Contacted_Owner.Value = no Then
Repair_Agreed.Visible = False
Combo17.SetFocus
Else

Repair_Agreed.Visible = True
Command39.Visible = False
Label40.Visible = False

End If

put that code in your forms On_Current event instead of a command button.. for each records that even will fire and trigger the code.

Cheers

[Bazzlad]

It isn't working!????!!!
Arggghh help!
Bazz

[Bazzlad]

Ok it's working now....alhough it wasn't???!!!???
Thanks for your help!
Bazz