Problem with Before Update and subform

[hende10]

I have an inventory ticket database that keeps track of part movement. This had originally started with paper sheets, so the main database entry form was designed to mimic the look of these sheets. Now I have a problem with validating input.

The entry form has a standard left-right/top-down tab order, and in the middle of the form is a subform where you can add multiple parts to the same ticket. After this subform (back into the main form) there is a field called Supervisor, which is required entry.

My problem is when the user tabs through the form, and enters in to the subform, the BeforeUpdate event kicks in before the user gets a chance to enter in the required data below the subform. I still need to mimic the original paper form, and I still need to keep the same tab order, so is there another Event that I can tie the validation code to?

Thanks,

Hende

 

[Remou]

Hi
The only way I can reproduce the problem you are describing is by setting the required property for a field to Yes; the Before Update event did not cause a problem. Here are a few ideas:
- Remove the required property and validate on the form.
- Set a value for Supervisor in the On Current event or such like.
- Use a multi select listbox and a recordset instead of a subform.