Disable parts of a form

[susancockburn]

I have a form split into 11 parts. Each part is completed by a different person in sequence and each part finishes when either a date or name is entered. What I want to do is to disable the parts already completed but leave the parts ready for completion by the next person.

I have put an Event Procedure to disable all the data entry fields above the date in Part 1 on the AfterUpDate of the date. Fine this works but when I then close and open the form again all the fields are again enabled.

I have now put into the Form Load a procedure to check if the date has data in or not, again fine. I have a command button on the form to enable users to create a new record by bringing up an empty form but of course it says it can't set the focus to the first field as it is disabled.

Is there any way to simplify this. All the previously entered data must be visible to those that follow.

 

[DALeffler]

You might try the OnCurrent event for having your procedures change the form's field properties when the user would like a new record; it might even be a better place for all your procs for the form control property settings when you open the form...

See Help, "Current event", (MA 97) for more info.

When you first open a form, the following events occur in this order:

Open, Load, Resize, Activate, Current

This event occurs both when a form is opened and whenever the focus leaves one record and moves to another. Microsoft Access runs the Current macro or event procedure before the first or next record is displayed.

HTH,

Doug.

[This message has been edited by DALeffler (edited 03-25-2001).]