Check Off Items in Form

[chaddiesel]

Hello,

I have a form that users type in a part number and a due date. I then run a
report that prints the part number, the components needed and the processes
needed. For example:

------User Form-------

Part 1 6/25/05
Part 2 6/28/05
Part 3 7/1/05


---------Report--------

Part 1 6/25/05

Component 1--------SAW-----WELD------SMOOTH
Component 2--------WELD-----PAINT
-------------------------------------------------------------
Part 2 6/28/05

Component 1--------DRILL-------WELD
Component 2--------SMOOTH-----PAINT
-------------------------------------------------------------
Part 3 7/1/05

Component 1--------DRILL-----PUNCH
Component 2--------CUT-------PAINT
-------------------------------------------------------------


What the users want the ability to check off (and make dissappear) the
processes each day, so they can see what processes are left.

For example, after day 1 with SAW and WELD done:

Part 1 6/25/05

Component 1--------WELD------SMOOTH
Component 2--------PAINT

I'm confused about how to go about this. I don't want the users to have to
manually type in anything. I want the components and processes to show up
when they type in the part number. I want the user to be able to check off
processes as they go, but I want all the processes to show up when they type
a new part in the form. I would appreciate it if someone would point me in
the right direction.

Thank You,

Chad

 

[trucktime]

Processes

Probably the easiest solution is to ad a Yes/No Field to the table,
which will give you a Check Box on the form.
That Field will indicate if the Process has been completed or not.

On the form you can put some code in the After Update Event of the
Check Box that, when checked, will disable the Field that holds the
name of the process.
Something like:

If Me.checkbox = True Then
Me.processfield.enabled = False
Else
Me.processfield.enabled = True
End If

Instead of disabling the field you can also change the field background
and foreground color.

If you want the processes that have been completed not to show
up on the Print, just use a Query, and set the requirement for the
Checkbox field to 'false'.

Good Luck