how?

[emanuele]

How do I make this happen? Could not find any help on the forum.

Thanks to IIkhoutx previous help, I am now able to have the value of a combo uppdating automatically when the value in textbox changes (Cool!)

I am now trying to make this happen but tried and tried without succeding: When the combo changes it´s value then msgbox "Value changed" and print report "New value found"

I am using access 2and windows 98. The Form has this event :

Private Sub Form_Current()
If Me!total >= 50 Then `total is the textbox
Me!status = 3 `status is the combo
ElseIf Me!total >= 20 Then
Me!status = 2
Else
Me!status = 1
End If
End Sub

I TRIED on DIRTY:
If ME!Status then

Dim stDocName As String

stDocName = "New Value Found"
DoCmd.OpenReport stDocName, acNormal

Am I heading anywhere?