Not running unless in specific cell

[mad-q]

Hello all,

I have a query which doesn't run properly unless the user has put the cursor in a cell which contains data. The data is in a subform. If they leave it in the bottom (make new) cell then it fails. Please can someone help with regards to either making the cursor go to, say the first cell, or how I can make the query not worry about where the cursor is.

The query sums a column in the subform.

Yours
Iain

 

[John Big Booty]

Can you post the SQL for your query or a copy of your DB?

 

[John Big Booty]

...and how are you firing the query?