Form Field Problem

[StefanSch]

I have a subform with the fields A, B, C and D.

When I try to click on field C (third field) of a specific record, the cursor goes first to field A (first field) of this specific record. When I then click again on field C, the cursor enters field C of this record (what I wanted to achieve with the first click already).

Is there a way, how I can set the cursor directly to field C with a mouseclick?

 

[Rich]

You have some code which is moving the focus

 

[StefanSch]

Thanks Rich

What exactly do you mean by that?

 

[directormac]

Rich - if it's a subform, could the first click, wherever it lands, be activating the subform, and since control "A" has the 0 tabbing index, it's getting focus? Stefan, try clicking on control "B" and see what happens.

Just a random thought...

Anyway, what Rich is referring to is a piece of VBA code somewhere that is telling Access to set focus on control "A". Look through the event properties for the the form, subform, and each control and examine the event procedures you find. See if any of them include the .SetFocus method.

--Random Mac

 

[StefanSch]

Hi directormac

Thanks for the response. The same thing happens if I click on control B.

This happens regardless whether the subform has already the focus or whether it just gets it.

 

[directormac]

Then, as usual, Rich is right. No surprise there. How familiar are you with VBA and event properties?

--Unsurprised Mac

 

[StefanSch]

I have been into VBA for about 5 months now (learned by doing and by learning from the great people in this forum). I have therefore just basic knowledge.

Do you agree with me that I will have to check the coding mainly in the OnClickEvents. Do you see any other events that could make this problem happen?

 

[directormac]

Any event could make it happen, but since it occurs when you click inthe subform, yep, yer probably right. Another place to check might be the .OnGetFocus of the subform.

What puzzles me a bit is how this code found its way into your forms to begin with. Did you create these forms & subs from scratch?

--Itchy Mac

 

[Rich]

I'm certain it's because of this
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=162657#post162657

 

[directormac]

Looks like I have to change my sig to "WWRD?".

--Apostle Mac

 

[StefanSch]

I agree. Rich is extemely good. He has prevented me many times from having a heart attack.

Many thanks to you both.

I'll try to solve this issue. At least I know now what makes this happen.