me.requery help

[bsnapool]

Hi All

I have added a me.requery within a checkbox but when I check the box it always goes to the first record, any reason why?

An example, if i tried to check the box on record 7, it would go stright to record 1.

Thanks in advance

Andrew

 

[Bodisathva]

Because the requery does exactly that, runs the initial query that the form is based on again, therefore resetting the cursor to the starting point.

 

[bsnapool]

Solved

All sovled, I used Refresh instead.