Thanks for your help! I really appreciate it. I've implemented a lot of your suggestions, and it truly helped. I took out the spaces in the naming convention and I took out the input box code and I made it just an input on the actual form. The last piece of the puzzle I'm trying to figure out is how I get the amount of work added from the form that the user inputs to add to the workers work total.
Right now my code looks like (For button 1):
Code:
Private Sub Command1_Click()
Dim strWorker As String
strWorker = DLookup("EmployeeName", "Table1", "ExcludeFromWork=False AND WorkCount=" & DMin("WorkCount", "Table1", "ExcludeFromRotation=False"))
Text1.SetFocus
Text1 = strWorker
Text1.SelStart = 0
End Sub
Any tips you can give me on how to get the number inputted from the user into the workers total count would be great. Thanks again for all your help!