J
Jeffrey O'Donnell via AccessMonster.com
I'm trying to automate some input on a form.
The purpose is to track employee evaluation reports. Currently, all information must be typed into the form. The fields include the employee's personal data - LastName, FirstName, MiddleInitial, their Location, Department, Section, and various dates.
We must also type in the Rater?s Name, the Rater?s Department and Section, and the Reviewer?s Name.
I was successful in creating combo boxes on the form for Location, Department, and Section as these are pretty standard. I also created a make-new-table query that combines LastName, FirstName, and MiddleInitial into one field (FullName) and also collects Department and Section from the table. This new table is named tblRater.
I then run a query from tblRater that limits the Rater?s Name, Department, and Section to only those raters that are in the same Department as the rated employee, as only someone in that department can rate an employee from that department.
The FullName field from this query (qryRaterComboBox) then populates a combo box on the form. The Rater?s Post and Rater?s Section text box display the Rater?s information with the following:
Private Sub RaterNameCombo_AfterUpdate()
Me!RaterPost.Value = Me!RaterNameCombo.Column(1)
Me!RaterSection.Value = Me!RaterNameCombo.Column(2)
End Sub
Unfortunately, the Rater's Post and Section text boxes in all records on the form display the same data. How do I limit the data to show only in the current record?
Also, after I select the rater from the combo box and the text boxes show his information, the data does not get captured and saved in the table. How do I get the data from the text box into the appropriate field in the table?
The purpose is to track employee evaluation reports. Currently, all information must be typed into the form. The fields include the employee's personal data - LastName, FirstName, MiddleInitial, their Location, Department, Section, and various dates.
We must also type in the Rater?s Name, the Rater?s Department and Section, and the Reviewer?s Name.
I was successful in creating combo boxes on the form for Location, Department, and Section as these are pretty standard. I also created a make-new-table query that combines LastName, FirstName, and MiddleInitial into one field (FullName) and also collects Department and Section from the table. This new table is named tblRater.
I then run a query from tblRater that limits the Rater?s Name, Department, and Section to only those raters that are in the same Department as the rated employee, as only someone in that department can rate an employee from that department.
The FullName field from this query (qryRaterComboBox) then populates a combo box on the form. The Rater?s Post and Rater?s Section text box display the Rater?s information with the following:
Private Sub RaterNameCombo_AfterUpdate()
Me!RaterPost.Value = Me!RaterNameCombo.Column(1)
Me!RaterSection.Value = Me!RaterNameCombo.Column(2)
End Sub
Unfortunately, the Rater's Post and Section text boxes in all records on the form display the same data. How do I limit the data to show only in the current record?
Also, after I select the rater from the combo box and the text boxes show his information, the data does not get captured and saved in the table. How do I get the data from the text box into the appropriate field in the table?