Capability Questions

[needing help]

I'm attempting to create an easier form for all individuals under my
supervision. I've created the database and form with the needed questions
and even included standard responses. But I'm curious though if I can
seperate the forms to only display information entered by certain offices.

The database is for customer requests. There are several offices and I want
each office to enter their information on a specific form but would like that
form to load to one database so I can report that information to my
supervisor, rather than compiling them like I already do on excel. Is that
possible?

 

[John W. Vinson]

I'm attempting to create an easier form for all individuals under my
supervision. I've created the database and form with the needed questions
and even included standard responses. But I'm curious though if I can
seperate the forms to only display information entered by certain offices.

The database is for customer requests. There are several offices and I want
each office to enter their information on a specific form but would like that
form to load to one database so I can report that information to my
supervisor, rather than compiling them like I already do on excel. Is that
possible?

You really need only one form; it should be based - not on your table - but on
a Query which lets you select the subset of records for that office. You could
for instance have a combo box (unbound, nothing in its Control Source
property) on the form which allows you to select an office, and filter the
form to show only that office's records.

 

[Stockwell43]

Hi,

To display information you want to create a report from your table and
display it on the form. The table is for storing your information, the form
is for inputting the information, the query retrieves the information and the
report displays the information.

 

[needing help]

How do do I set up a 'combo box'?

You really need only one form; it should be based - not on your table - but on
a Query which lets you select the subset of records for that office. You could
for instance have a combo box (unbound, nothing in its Control Source
property) on the form which allows you to select an office, and filter the
form to show only that office's records.

 

[John W. Vinson]

How do do I set up a 'combo box'?

Open the form in design view. Use the Toolbox - be sure the magic wand icon is
selected, and choose the "Combo Box" tool.