Required fields in form? Help.

[GoinDeep]

I have a form bound to a table of past data. On the form I have a series of check boxes that when checked a number of related textboxes must be updated, cannot be Null.

The problem is I cant set the bound tables fields to required but I need to have the forms fields contain a value when updated.

For example on record 1, I check "Replaced Equipment X" and the "Date" and "Mfg" of the new equipmet X must be entered, the previous value may or maynot be null.

Any Ideas?

Thanks in advance!

 

[Uncle Gizmo]

Do you just want to update the date field?

 

[GoinDeep]

No, I have several (approx 12 or more) fields that need to be updated depending on which check box is selected.

 

[Uncle Gizmo]

For clarity’s sake, I understand that you have “Past Data“ In Your table. On your form you have checked boxes and text boxes. Are the check boxes and text boxes linked to fields in the same table as the “Past Data “? Or are they linked to another table. Or are they unbound?

 

[GoinDeep]

For clarity’s sake, I understand that you have “Past Data“ In Your table. On your form you have checked boxes and text boxes. Are the check boxes and text boxes linked to fields in the same table as the “Past Data “? Or are they linked to another table. Or are they unbound?

The form is bound to a "temporary table" created from appending all the fields in the "Past Data" table with the addition of the check box fields.

When the updates are completed (via form in question) queries update the "Past Data" table and append historical data to a "history table". The contents of the "temporary table" are then deleted until the form is opened again.

 

[Uncle Gizmo]

So the check boxes are bound and the text boxes are unbound?

 

[billyr]

In response to the checked box(es), are you editing past history record(s) or are you displaying past history but adding a new history record? It sounds like you are working on a service data system.

Regards,
Bill