function in query executes more than once?

  • Thread starter Thread starter sparkane
  • Start date Start date
S

sparkane

I have a custom function in a query which gets a new ID number for a
record. I've noticed that the query increments the new ID number 3
times rather than once - and when I put a break point in the function, I
discovered that it is indeed executing 3 times.

Can anyone tell me why this might be happening? The function is called
in the query only once.
 
I believe the function will be called each time the query re-draws.
Scrolling through the query will recall the function. You might want to
reconsider your solution (whatever it does).
 
Back
Top