Recent content by robtperk

I have a form listing tasks to which I make personnel assignments with a multi-value list field type. It takes some time to select from 15-25 employees on the list for each task, especially considering that small groups of employees will be assigned to the same selection of tasks. What I want...

Thanks JANR. The following worked like a charm: [BEGIN CODE] DELETE tblWorkTasks.Employees.Value FROM tblWorkTasks WHERE (((tblWorkTasks.Employees.Value)>-1)); [/END CODE]

Yes. Doing so otherwise would cause me to create a cumbersome and hard to use form.

How do I clear values in a multi-value field in code. It seems it won't work in an update query. The field values are numeric long.

Thanks for your suggestion. I went at it another way. I created my task/operation list, which luckily I could do in this case, and added a selected Boolean field. This was the source of a datasheet sub-form on an unbound main form. The main form provided a crewID which was the last piece of...

Thanks. Let me explain a bit more. I have a list of employees and a list of un-finished tasks, each with a budgeted number of hours for the task. Each week I will bring up an employee's name in the main form, then select a few of the unfinished tasks in the sub form below. From this, plus...

I need to create some new records based on main form data and a selection of records from a sub form. The main form and sub form have different sources. I wanted to show the source fields in the sub form along with a check box to allow the users to select individual records. The record source...