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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform with no records 8
Access Main form/Subform Navigation 0
First Subform record gets modified when closing form 3
Using an append query in a subform 1
Trouble associating parent form record to subform's record 1
data entry in subform before mainform causes huge hassle, HELP! 2
VBA Syntax for subform record source change 6
Records in form and subform 1

Back
Top