Search results for query: *

I pasted this code in to the AfterUpdate() event procedure of the cbEmployee on the main form. When I run the form, and I select an employee from the combo box, I get the following error: When I click Debug, the first line you sent me (Forms![DailyLog]! etc.) is highlighted. Unfortunatley, I...

Hi Bob. Thanks so much for your help. I'm not sure where I'm supposed to modify the SQL for the SubForm, using the code you gave me. I added it to the BeforeUpdate for the subform itself; the project list is populated, but with every entry in the project table (the list isn't limited to the...

The Row Source for the Employee combo box on the main form is: SELECT Employees.EmployeeID, Employees.FullName, Employees.teamID FROM Employees WHERE Employees.teamID=7 ORDER BY Employees.FullName; When the form is first opnened, the Employee field's visible property is set to false. The...

Let me add two things: First: I realized this is probably in the wrong thread. Sorry about that. I meant to place it in a new thread. Second: I know where the problem IS in the code. I just don't know how to fix it. When the user is selected, the program takes the user's Employee ID, and shows...

Ok. Now I am working with two forms: DailyLog and Log_sub. On DailyLog I have the end-users select their name. The following event procedure runs AfterUpdate: Private Sub cbName_AfterUpdate() Log_sub.Visible = True Form_Log_sub.cbProject.RowSource = "SELECT Projects.projectName...

Thank you. We had already tried something similar; I'm not sure what we did wrong, but this works GREAT. You were VERY helpful!! Thanks again!

scriverb, I am trying to do something similar. I am a team leader, and am having my team members keep track of their work using an Access Database. I use a query to create a report on the logs that were entered in the last eight days (I run the report on Mondays). However, I would really like...