continous form data
in [Form]
|
From: ashraf_al_ani via AccessMonster.com on 28 Apr 2010 05:10 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
From: BruceM via AccessMonster.com on 28 Apr 2010 07:15 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
From: ashraf_al_ani via AccessMonster.com on 28 Apr 2010 07:29 thanks for help but i mean the value for a record in that continous form if the value is 100 then ive got the message but i want that happen when i open the form directly and not searcching for the record is there a way to handle my problem?? best wishes 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
From: ashraf_al_ani via AccessMonster.com on 29 Apr 2010 02:37 ashraf_al_ani wrote: >thanks for help >but i mean the value for a record in that continous form if the value is 100 >then ive got the message > >but i want that happen when i open the form directly and not searcching for >the record >is there a way to handle my problem?? > >best wishes > >>Dear All >>I have a continous form that have 25 records in its detail section >[quoted text clipped - 8 lines] >>any ideas??? >>best regards so please isnt there a way to apply a condition to a specific record in the continous data ?? please any ideas ??? best regards -- Message posted via http://www.accessmonster.com
From: BruceM via AccessMonster.com on 29 Apr 2010 07:26 You could use DLookup. If the continuous form is a subform, in the main form's Current event: If Not IsNull(DLookup("YourField]","[YourTable]", _ "[YourField] = 100 AND [ID] = " & [ID])) Then MsgBox "Your message" End If [YourField] is the field that could have a value of 100. [ID] is the linking field. Use your actual field names. Repeat the code for other values. If the continuous form is the main form, place the code in the form's Load event to see the message when you first use the form. ashraf_al_ani wrote: >>thanks for help >>but i mean the value for a record in that continous form if the value is 100 >[quoted text clipped - 11 lines] >>>any ideas??? >>>best regards >so please isnt there a way to apply a condition to a specific record in the >continous data ?? > >please any ideas ??? > >best regards -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201004/1
|
Pages: 1 Prev: Combo box problem Next: Form label showing extra character at end of label |