View Single Post
  #2  
Old April 28th, 2010, 12:15 PM posted to microsoft.public.access.forms
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default continous form data

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