Cursor problem with subforms

[JohnUgoji]

when I input data in my forms with a suform, the cursor moves into the first field in the subform but after a few records it will jump to the last field on the subform and i will have to manually insert it in the beginning. What do i do to steadily have the cursor move to the first record on the subform.
Thanks.

 

[vbaInet]

Can you upload a test database so we can see what you're experiencing?

 

[JohnUgoji]

Hi,
Find the attached access db. i have 2 problems with it:
1. the cursor problem
2. the calculated control on the form is showing an error message.
Can you help.
Thanks.

 

[boblarson]

Are you using a laptop?

 

[JohnUgoji]

Yes I use a laptop.

 

[boblarson]

Yes I use a laptop.

I figured from your description but just wanted a confirmation.

You want to know why the cursor is jumping? Your palm is hitting the touchpad. What you should do is see if your touchpad driver lets you set it so that it is disabled automatically when typing. Then you won't have that problem.

As for the calculated control, make sure you don't

1. have any of the parts dividing by zero or by something that could be zero.
2. the name of the control that the error is happening in isn't the same name as any field used in any calculation formula on the form.

 

[JohnUgoji]

Hi Boblarson,
THanks very much. Did I mean the cursor jumping? No. I mean that the cursor does not enter the first field in thethe subform as it emerges from the mainform form; it enters the last field and I have to manually send it back to begin inputting data. It happens on my desktop too.

On the calculated control I agree with you but I have checked and checked and cross checked my names but I haven't seen my mistakes. I still end up getting #name?

Thanks for your help. I want some more.
John

 

[JohnUgoji]

Hi Boblarson,
THanks very much. Did I mean the cursor jumping? No. I mean that the cursor does not enter the first field in thethe subform as it emerges from the mainform form; it enters the last field and I have to manually send it back to begin inputting data. It happens on my desktop too.

On the calculated control I agree with you but I have checked and checked and cross checked my names but I haven't seen my mistakes. I still end up getting #name?

Thanks for your help. I want some more.
John

 

[boblarson]

Well, your name problem comes from an incorrect formula. Your formula in the text box named Text27 on the ChapterTransMaster form should have the formula:

=[Items].[Form]![Text11]

Not what you currently have:
=[ChapterTransDetail].[Form]![Subtotal]

As for the jumping to the wrong control when tabbing through, I couldn't replicate the problem.

 

[JohnUgoji]

Hi Boblarson,
Thanks a lot. I will let you if worked on my copy. Thanks once again.
John.

 

[JohnUgoji]

Man! it worked. Then I can get cracking. Thanks.