tab to next record

[samos1023]

I have a main form with a sub form. The sub form is a continuous from. The form is for entering items into a inventory tracking db. When I get to the end of the current item the tab key takes me to the beginning of the record, can I set up my form to go to a new record when this is triggered? The second thing is If I click on a new record when i have finished entering a record(instead of hitting the tab button). When this is done the cursor moves all the way to the first record in the form. What can I do to change this behavior

[John_G]

In the property list for the form, look for the Cycle property. Click the General tab if you can't find it. Set the Cycle property to All Records and it should behave as you want it to.

[samos1023]

When I set my cycle to all records, then my behavior changes. The first time I get to the end of a new record I get the same behavior as before. The cursor returns to the first item in the first record on the sub-form. If I push tab from this point the tab travels down the item list and then to the next. What am I doing wrong

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[isladogs]

Check the tab order of the fields in your subform: Design menu ... Tab Order.
If the order is wrong drag items into the order you want or use Auto Order

[samos1023]

I have put a zip file in my dropbox for you. The DB has a front end and a back end. I gave you both files. There is also user security on it so hold shift when opening the DB to bypass the login requirments

https://www.dropbox.com/s/iqen1ygh87...0Rev2.zip?dl=0

[isladogs]

Which form is it?

[samos1023]

frmInvCheckInEquip

[isladogs]

All fixed
3 other forms accessed from the switchboard also had the tab order scrambled so you got 'silly behaviour' in those as well
- frmOpenInventory
- frmInvCheckOutEquipSub
- frmAllOpenProductsSub
In each case, I clicked on the Detail section in design view then changed tab order using Auto Order

There may be other forms that I've missed if not opened via the switchboard

Attached is the updated FE - no point uploading the BE as I haven't changed it.

AV Database Rev2.zip

[samos1023]

I deleted my old DB and replaced it with the one you sent, I still get same results. I also opened up the form in design view, I dont have a tab order for the detail view, each item in the detail view has a tab property, is that the one your referring too?

[isladogs]

The form you mentioned behaved perfectly for me so I didn't change it
Try doing what I described re Auto Order on that form

[isladogs]

Here's a short video of what I get together with a screen shot of how to alter the order

BTW I get a missing reference message for ACWZTOOL.ACCDE when I run your db.
That's the built in Access wizards so I don't know why that is or whether its relevant

Oops - screenshot for wrong form ... but same idea