Auto populate Record information in form

  • Thread starter Thread starter davis1189
  • Start date Start date
D

davis1189

I have a database filled with 60 records of various
projects that have 20 fields. I have created a form with
all 20 fields and one of those fields is the project
manager's name. There are eight different project
managers with more than one project each. Currently the
only way to go to each record is via the navigation
buttons. What I would like to happen is for each project
manager to be able to go in the database and key in their
name and the rest of the information for their projects
fill in without them having to use the navigation
button. I created a combo box to do this but it only
pulls up their first project (record). How can the
project manager review all of his records, one right
after the other? Can you please tell me how to do this
in MS Access 2000?
 
How can the
project manager review all of his records, one right
after the other?
Click to expand...

Base the Form on a query selecting the manager, rather than directly
on the table.
 
I have a database filled with 60 records of various
projects that have 20 fields. I have created a form with
all 20 fields and one of those fields is the project
manager's name. There are eight different project
managers with more than one project each. Currently the
only way to go to each record is via the navigation
buttons. What I would like to happen is for each project
manager to be able to go in the database and key in their
name and the rest of the information for their projects
fill in without them having to use the navigation
button. I created a combo box to do this but it only
pulls up their first project (record). How can the
project manager review all of his records, one right
after the other? Can you please tell me how to do this
in MS Access 2000?
Click to expand...

A number of different things may be happening here. The optimal way of doing things would be to have one table with the
manager information seperate from your project table and simply select the manager in the project entry. This prevents one
thing that may be happening, which is that the manager name may be mis-keyed on entry or spelled in various maners. You may
simply check the manager names to see that each manager is spelled correctly instead but it will not prevent such problems in
the future.

In the combo box to select the manager, do you filter the form to only that manager or simply move to the first project that
the manager has? Use the form's Filter property to set the filter and then set the FilterOn property to True.

Me.Filter = "ManagerName = """ & Me.ManagerCombo & """"
Me.FilterOn = True

Of course, replacing [ManagerName] with the correct field name for the manager and [ManagerCombo] with the correct name for
the manager select combo you created.

Jeremiah Ellison
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top