cascading combo box skips past next field

[mdemarte]

Thanks to this forum, I have learned what cascading combo boxes are and how to set them up. I have at least three databases with them. I checked all 79 posts for cascading combo boxes, to no avail. Now, here is the problem that I am having:

After I pick data for the first combo box, it should tab to the next field on the form to the right. Instead, it skips over several fields. If I just tab through the form (no change to the first combo box), it tabs to the next field as it should.

On the After Update event, I have Me.Requery. I tried to follow that with SetFocus to the correct field, but no dice. I tried SendKeys "{Home}{Tab}" (since it is the second field) and that did not work either.

I just checked another database and it does this unexpected activity as well.

I am using Access 2000.

Quick note: there seems to be a problem downloading from Candace Tripps site. I will try to e-mail her.

 

[boblarson]

In the form's Design View, go into View / Tab Order and see if the tab order is set properly. You can set the order here. If you don't want something to be able to be tabbed to, then go to the properties of that control and select Tab Stop and mark it No.

 

[Rich]

Me.Requery is requerying the whole form, you only need requery the next combo

 

[mdemarte]

boblarson: Um, thanks for the reply -- but if you read my first post again, you will see that the tabs in the form were working properly.

rich: Thanks! I changed it to requery the item in the sub-form (actually, I requery an item in each of two sub-forms). That worked like a charm. But, it left the cursor on the field. So, I added an entry to the event, SendKeys "{Tab}", to go to the next field. That fixed that problem.

New Problem: However, if I tab through the whole form so that it brings up the next record, then it doesn't start with the first field anymore like it should -- it jumps over a couple of fields. There is no event tied to the form, the field is indexed 0, allowed tab stops, and the only event tied to it is the After Update. ARGH!