
06-08-2009, 10:06 PM
|
| Database Newbie | | Join Date: Jun 2009
Posts: 1
| |
Cascading Comboboxes - how do I save the results on the form?
Hi
I've set up a set of cascading combo boxes in access. The purpose is for my staff to track their daily tasks each day/week. The form has the current date and time along with a drop down box where they can select their name and a check box for marking the task complete. The first combo box lists the task category (AM, Mid-Day, PM, or weekly) and the 2nd box lists the associated tasks depending on what is selected in the first box. It all works 100% from the selection standpoint. However, since each of the combo boxes are unbound, I cannot figure out how to get the product of the selections to save to a master table. All that show on the master table are the date, the time, the agents name, and that they've completed the task. How do I get the task category and the task name to save as well?
|