arage
08-14-2001, 12:12 PM
need to replace a part of my function
here’s my below function
Me.EventNumber = Nz(DMax("eventnumber", "newquery", _
"regionaldirectorcode= " & glblDirCode & "And promotiontype= 'OA'")) + 1
the above was meant to generate a reference# for my data entry system AFTER the user would enter a value & do some error checking etc….
Currently however I’m making verion 2 of my form, how might assign a value to my control (me.EventNumber) using a function that will only act upon the forms filtered results or how might apply a the filtered results to the function above?
here’s my below function
Me.EventNumber = Nz(DMax("eventnumber", "newquery", _
"regionaldirectorcode= " & glblDirCode & "And promotiontype= 'OA'")) + 1
the above was meant to generate a reference# for my data entry system AFTER the user would enter a value & do some error checking etc….
Currently however I’m making verion 2 of my form, how might assign a value to my control (me.EventNumber) using a function that will only act upon the forms filtered results or how might apply a the filtered results to the function above?