Using a Form for Data Entry, Searches, and Queries

R

Rosemary

Hi,

We have one single main form we use to view records in our
database. This main form contains 4 subforms, which
display various categories of information. This main form
is driven by the name of the individual whose information
is being kept in the database.

Right now, I am using the main form to search and edit the
database.

What I want to do now is prepare the database for use by
multiple users. On my Switchboard, I want a choice
for "Data Entry", a choice for "Search Database"
(generally a single record at a time), and a choice for
Querying the database using either a single or multiple
criteria.

The form I want to use for all these purposes is that one
single main form I mentioned above. It has everything we
need in it. With this in mind, how is it best to set up
the form for all the purposes I illustrated? Do I need to
set up a separate set of the main form for each task (data
entry, search, and query)? If so, I guess I would be
literally copying the same form over again, but just
giving it different names.

I'm not sure where to start with this part of my database
development - I hope my question hasn't been confusing.

Thanks!
Rosemary
 
Top