I have a form I'm making with a timesheet. My employees have to enter the data, their employee id, the amount of hours spent, and the grant name of the project they're working on. This all goes into my Timesheet table. The problem I'm running into is I want a combo box to be a drop down choice for the grant name. I have the combo box linked to my Grants table that has the list of the grants. The problem I'm having is it doesn't enter the data into my timesheet table when it's filled out. Is there a way to make this work or am I going about it wrong?
Thanks!