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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

When queries fire more than once 7
Use In() Expression as Query criteria with guts from Function 1
Append Query and Combo Lookup Problems 1
Max Query 2
List all records that appear more than once 1
subquery in group by query 3
Loop Query values 2
Query on SQL Server is fast, while Access is crawling 2

Back
Top