add new entry form

[ddskorupski]

I have a form that is used to enter data. It opens to a blank form by default. The form is based on one table. On this form I have an entered field. Is it possible to have some type of control that when a date is entered in this field and checkbox field in another table gets checked?

 

[HiTechCoach]

You could use the After update event of a control to do this, but I am not sure that you really should. The check box in the other table is like calculated change and should NOT be duplicated/store. I owudl recommend that you calculated as needed.


For Example, on a report you could set the control source of a check box to be:

=Isdate([YourdateField])


If these is a data, the check box will show as checked. This will ensure that the check box is always accurate.

 

[ddskorupski]

Thanks. But I actually have to track the cycle and with each document received the life cycle is given a percentage complete. For example:

if a script is received then the cycle is given 30 points
if a result is received then the cycle is given 30 points
if an approval is receieved then the cycle is given 40 points

We want to see where each application is at from a percentage standpoint

right now I'm tracking in three tables. Can you help me with a better design that will give me what I need?