Combo box form question

[abarin]

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!

[pbaldy]

It should have a control source of the appropriate field in the timesheet table.

[abarin]

Thanks!

Since the timesheet table is empty is it possible to have it populate the combo box with options from the grant table to input into the timesheet table?

Thanks again

[pbaldy]

The combo's row source should get the options from the grants table. It's control source should be the grants field in the timesheet table. The wizard should walk you through this.