Tabbing amongst Subforms

[TobyR]

Hi guys

I have a form with a large amount of subforms on it.

The problem I am having is that I cannot tab between subforms when entering data.

The cursor just moves within the subform and browses off of the current record (Creates a new record, like when scrolling the mousewheel).

Anyone know how I can set it up so that I can tab betweek all subforms across the entire form and not create a new record?

In addition, I know access 2000/97 users had to use custom code to disable the mousewheel, but I read something somewhere saying that you can disable it in Access 2003 without using code? How do I do this?

Thanks,

Toby

 

[alastair69]

1. On the last text box you need to have a setfocus procedure, this is normally some thing like:
me.[Subform Name].Setfocus
or you could try:

Me.[Subform Name].RowSource = [Your Fist Text box on subform] = SetFocus

This will move the entry into the given form.

Let me know if any of these do not work and i will try some other route.

I am not sure how to disable the mouse wheel.
Alastair

 

[alastair69]

After a simple forum search is have found an example of how to disable the mouse. please follow the link
http://www.lebans.com/mousewheelonoff.htm

Alastair

 

[TobyR]

Hi

Thanks for your help, I have the code to disable the mousewheel, but I've heard a mention somewhere that you can turn it off within Access 2003 without using code?