Tab order problem 2

[SoClueless]

Hello all...

I have made some changes to the table and form of a little database. The fields are all in the table propeties list in design view and they all appear on the form. However, when I click view, tab order, there is a new field missing and one or two which I thought I had eliminated. As a result I cannot get the tab to work properly.

Any ideas on what to do? Feeling ridiculous...thanx!!

Clueless Me

 

[TheAceMan1]

How are ya SoClueless . . . . .

Make sure the [blue]Formatting ToolBar[/blue] is on screen. On the extreme left of it is the Object Combobox. All the controls on the form are in the dropdown list.

If you do'nt see the missing field here, then it wasn't included and you'll have to instantiate it again. If you do see it, select it in the list, then use Ctrl-Up/Down/Left/Right to move i so you can tell where it is.

For those that should have been eliminated, select them in the list and hit Del.

See Ya! . . . . . .

 

[RickSpr]

This may be obvious, but if the new control is not one which can receive focus it will not appear in the tab order dialog.

However, since you say you have a couple controls which you've deleted, it sounds like the form has some corruption damage. You might want to examine the form in design view, looking at the control names in the object name combo box on the Form Design toolbar, just to be sure the controls have the names you intended.

If corruption seems to be the answer, create a new database and import everything into it. (Don't forget to set up your References in the new database, and remember to import the items on the Advanced part of the import dialog.) At the worst, you might have to recreate the new control and delete the ones you had eliminated.

Corruption like this just happens from time to time, usually as a result of an unusual sequence of operations in the development environment. For example, in Access 2000, if I click the Save button when I have more than one unsaved object, and then I un-highlight one or more objects (so they won't be saved right then), I always seem to have problems with the unsaved objects.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein