Tabular view, Navigation Buttons, & Primary key display...

[Scott]

I have a form that queries a look up table. The table is
set up with a primary key, not autonumber, and a
department description. Access defaults to the first
field, other than the primary key field when in a tabular
view.

Well, I need to evaluate the primary key entry to avoid
the default error messages for duplicates because they
aren't very well writtenby Access and it creates a
circular problem making the program crash, but Access
won't acknowledge the primary key field as the first
field in the recordset, it defaults to the next one
making evaluation of the primary field disrupt the order
of things.

The problem is I can set the focus to the primary field
and I can disable the warnings, but it disrupts the
tab/enter key operations and won't allow selections on
the click of the mouse.

Does anyone have an idea or solution?

Scott

 

[Larry Linson]

When you say "Access defaults to the first...", are you talking about using
one of the Wizards to create your Form? If not, please clarify, because I am
puzzled by what you say. If so, you can open the Wizard-created Form in
Design View and modify it 'most any way you want to.

Larry Linson
Microsoft Access MVP