Fast Love. I mean Help. (Solved)

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

Quote:

---

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

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

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