agregate funtion error in a text box on a access project file

  • Thread starter Thread starter =?iso-8859-1?Q?Luis_Assun=E7=E3o?=
  • Start date Start date
?

=?iso-8859-1?Q?Luis_Assun=E7=E3o?=

hello
i have upsized a .mdb file to connect it to sql server and
I created a microsoft access project (adp).
the problem is that I have aggregate functions in some
text boxes in the forms, like =DLookUp("forms![R0UTI001]!
[EventE]";"forms![R0UTI001]![PREEVENT]";"[Ref1]=forms!
[R0UTI001]![Combo552]"), in the control source of the text
box, that in run mode display a error message. this did
not happened in the .mdb file.
why is this happening?
Thanks
 
Hi,


Try:

=DLookUp(forms!R0UTI001!EventE; forms!R0UTI001!PREEVENT; "Ref1=""" &
forms!R0UTI001!Combo552 & """" )




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top