Subform moves to new record

  • Thread starter Thread starter Steven K0
  • Start date Start date
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...
 
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)
 
Another possibility is that code is running for the subform control's
OnEnter property.
 
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.
 
Back
Top