Subform moves to new record

S

Steven K0

Hello,

I have one form that as soon as I click on the subform, the main form moves
to another record. I have created different forms with the same table with
the same result. This doesn't happen with any of my other tables or forms
(SQL Server 2K and Access XP).

Any help with this would be greatly appreciated...
 
J

John Vinson

Hello,

I have one form that as soon as I click on the subform, the main form moves
to another record. I have created different forms with the same table with
the same result. This doesn't happen with any of my other tables or forms
(SQL Server 2K and Access XP).
Click to expand...

I've never seen this happen! Do you have any VBA code in either form -
particularly the mainform's BeforeUpdate or AfterUpdate events? Note
that these events will fire when you setfocus to the subform.

John W. Vinson[MVP]
(no longer chatting for now)
 
K

Ken Snell [MVP]

Another possibility is that code is running for the subform control's
OnEnter property.
 
S

Steven K

Thanks John,

No, the same thing happened when I created a form and subform using the form
wizard just to make sure it wasn't an issue with the code.
 
Top