I have a database to keep track of employees' hours worked on projects for billing purposes (i.e. employee x worked 5 hours on project=excel for client=microsoft). These are referred to as 'Daily Tasks.'
I have a form that allows employees to enter new Daily Tasks or update old ones. I have a cascading combo box, called 'cboProjectID,' that queries based on on the client selected. It works correctly when entering a new record.
The problem is when updating a record. The projects box is blank when switching between records.
Comment: I have the query run when the combo box is brought into focus.
Is it possible to have the combo box display the value if it exists (like the default value)?
Thanks for any help! Let me know what files or code I need to attach.