Subdatasheet problem

[AnnPhil]

My form with the subdatasheet is doing strange things with i view the data. It is not always consistent when this happens which makes it harder for me to figure out what the problem is. I hope someone can help me. Here is the problem; when i click on the plus sign to view the subdatasheet information it kicks me back to record one of the main form. This does not happen every time and i can not get it to do this on the same record either. This if very fustrating can anyone help?

Thanks in advance.

 

[Rob.Mills]

What's the code behind the button?

 

[AnnPhil]

There is no button, but i did find out that there was a requery macro tied to an event, i took that out and it seems to fix the problem.

Thanks for replying