entry page/form/whatever for db

[EdLeeYoung]

I've created many tables, queries, and forms for different things...all this
is confusing our data entry person who only uses certain objects. I want to
create an object she can access just the things she uses.

I searched my Office 2000 bible...but I know it can be done cause I saw it
in a demo years ago. Can anyone point me in a positive direction?

 

[EdLeeYoung]

Switchboard....that's what I'm wanting to create. Nothing in my book and most
the stuff I find on the web is more than confusing.

 

[John Vinson]

I've created many tables, queries, and forms for different things...all this
is confusing our data entry person who only uses certain objects. I want to
create an object she can access just the things she uses.

I searched my Office 2000 bible...but I know it can be done cause I saw it
in a demo years ago. Can anyone point me in a positive direction?

The Switchboard Wizard would be one option. Another would be to
construct your own switchboard form, and have it as the default form
on opening the database. I like to use a Listbox displaying
human-meaningful names of the various forms, reports etc.; in the
listbox's Doubleclick event you would put code to open the object in
the (invisible) second column of the listbox.

Just FWIW, users should generally not ever need to look at raw Tables
or query datasheets - forms are much more flexible and powerful for
interacting with data.

John W. Vinson[MVP]

 

[EdLeeYoung]

Nevermind! I found it. Thanks.