My form is on drugs: Updates a different record than shown

[HappyCoda]

If this bizarre issue has been addressed earlier or I am missing something fundamental, please forgive me...

My garden variety form is based on a simple table ("Issues"), has a tab control with a few subforms on a couple of its pages...pretty ordinary...but it behaves like a thing possessed!

It opens on the first record (IssueID 48), I ask from VB what IssueID it's on? 48. Great. I move to the next IssueID on the form and it displays IssueID 49. I then ask VB: "? form_Issues.IssueID" and it tells me 48!!!!

I am or my form the crazy one? I know you'll need more info to answer, but has anyone heard of anything like this???
Cheers,
Josh
_____________________________________________
Helpful info? :

1. Access project + SQL Server back end on MSDE
2. Access 2002, Win XP Home 2002 SP2
3. I am left-handed
_____________________________________________

 

[HappyCoda]

Ok, I think I've found the bug! The form was not on drugs, because that is just silly. No, the form has a GHOST!!!

I'm not kidding. When I open it, two versions actually open!!

So, what I am querying from VB and what I am looking at are actually two different instances of the form. Wierd stuff....

I have some investigating to do...

 

[HappyCoda]

Yep, found it. When I call , [formname].recordsetclone, the form is automatically opened.

Something like that.

I've coded my way around it.

But thanks, forum, for your help. Just posting it here seemed to do the trick.