A
Ann Scharpf
I am very novice at using forms, events etc. So I've been reading the posts
here about using combo boxes and subforms and I'm pretty lost.
I created a query to list EmployeeName and TerminationDate from my Employees
table. (Did this because I saw it was the way to sort in alpha order for my
combo box. The Employees table is listed in EmployeeNumber order.)
I have a subform that shows the employee's project/hour assignments. I want
to have them come up so I can zero them out. I related the two with the
EmployeeName, which is in both the query and the subform. (I know that you
could probably write code to find the records and zero out the hours but I
wouldn't have a clue how to do that. I THOUGHT I could tackle this subform
thing...)
When I select the EmployeeName in the combo box, it is not updating the
records that display in the subform. They stick with the assignments for the
employee who appears first alphabetically in the EmployeeTable.
If it is not too much trouble, could someone please explain ... like you're
showing this to a six year old! ... how to make this work?
Thank you so much for your help.
here about using combo boxes and subforms and I'm pretty lost.
I created a query to list EmployeeName and TerminationDate from my Employees
table. (Did this because I saw it was the way to sort in alpha order for my
combo box. The Employees table is listed in EmployeeNumber order.)
I have a subform that shows the employee's project/hour assignments. I want
to have them come up so I can zero them out. I related the two with the
EmployeeName, which is in both the query and the subform. (I know that you
could probably write code to find the records and zero out the hours but I
wouldn't have a clue how to do that. I THOUGHT I could tackle this subform
thing...)
When I select the EmployeeName in the combo box, it is not updating the
records that display in the subform. They stick with the assignments for the
employee who appears first alphabetically in the EmployeeTable.
If it is not too much trouble, could someone please explain ... like you're
showing this to a six year old! ... how to make this work?
Thank you so much for your help.