A field, not a record, will have a value. Under what circumstances would you
have the message box appear? How would you identify record 3? What exactly
distinguishes it as record 3? Does it have the value 3 in a specific field?
You could have code in the form's Current event to generate a message box
when you select a record:
If Me.RecordID = 3 Then
If Me.SomeField = 100 Then
MsgBox "Your message"
End If
End If
ashraf_al_ani wrote:
Dear All
I have a continous form that have 25 records in its detail section
is there a way to deal with one record among these 25 records
and I mean by that for example
if the record 3 has a value "100" a specific messsage box appears
the record 7 has a value "200" a specific messsage box appears
any ideas???
best regards
--
Message posted via
http://www.accessmonster.com