Question Start at First Filed in Subform

[Shazz]

Start at First Field in Subform

Can anyone help me, I have a form that has a subform within it, when I first open the form and tab to the Subform it always starts at the first Field, but after adding 1 record the next time I tab to the Subform it always starts at the field that I ended on in the previous entry.

Please can anyone help me, it is really annoying that I have to tab back to filed 1 everytime.

Shazz
x

 

[MStef]

In Sub On_Current, (in subform) put this code:

Me.FirstFieldName.SetFocus

 

[Shazz]

Hi,

I have done this but the database keeps flashing up an error saying Cant find the object "me".

Shazz

 

[Kryst51]

Hi,

I have done this but the database keeps flashing up an error saying Cant find the object "me".

Shazz

Where exactly are you putting this? Are you by any chance putting it in the properties screen? If so that is why. You need to remove it from there. Then click on the arrow that appears to the right of the "On Current" event. Then, from the drop down list, click Build Code (or something like that, my computer is tied up with a slow running query so I can't check). Then a vba screen should pop up, and you put your code between the Sub heading and "End Sub" lines.

If you have already done this, then I don't know what the problem is.

 

[Shazz]

Thanks, this is now working a treat, thanks for you patience we me as I am a Newbie to all this.

Shazz
x

 

[Kryst51]

Thanks, this is now working a treat, thanks for you patience we me as I am a Newbie to all this.

Shazz
x

Great! I am glad you got it working.