Honestmath
Technical User
hi,
i have a form that has a query as its record source. when i execute the query outside the form, it works fine, the query executes and stops. when i put the form into datasheet mode the query works fine there too, it executes and stops.
when i go into form view, it says "calculating ..." perpetually and won't stop. i can actually make it stop by switching to the VB module and then back.
what the crap is going on??!!! how do i get it to stop in form view???![[mad]](/data/assets/smilies/mad.gif "[mad] [mad]")
i don't know if it makes any difference, but the query calls a user defined function that does a lookup in a table, no changes. i don't see how it matters as the query works in all but form view.
thanks for keeping me sane!
math
i have a form that has a query as its record source. when i execute the query outside the form, it works fine, the query executes and stops. when i put the form into datasheet mode the query works fine there too, it executes and stops.
when i go into form view, it says "calculating ..." perpetually and won't stop. i can actually make it stop by switching to the VB module and then back.
what the crap is going on??!!! how do i get it to stop in form view???
i don't know if it makes any difference, but the query calls a user defined function that does a lookup in a table, no changes. i don't see how it matters as the query works in all but form view.
thanks for keeping me sane!
math
