Disable Tab Pages 1

[cpsqlrwn]

I have a subform that contains a control tab with 4 tab pages. On one of the tab page forms, I am trying to use the Dirty event to set enable to false for the other forms on the other tab pages. Trying to prevent a record being saved by jumping to another form. Forcing the use of a command button to save the record, and am having trouble with the code to disable the forms on the other pages.

 

[TheAceMan1]

Howdy cpsqlrwn . . .

All you should have to do is set the subforms [blue]Cycle[/blue] property to [blue]Current Record[/blue] . . . [purple]no need to set enable . . .[/purple]

See Ya! . . . . . .

 

[cpsqlrwn]

I need to clarify. I have a subform which is set to cycle current record. On the subform, in addition to several data entry controls, is a tab control with 4 tab pages. One page is add only, one page is delete only, one page is edit only, and one page is locked and used for viewing data only. When in the edit page, which has only one editable control, a quantity used control, I want to prevent a change from being saved by clicking into one of the other tab pages (saving the record by leaving the form). The main form and subform controls have all been disabled. What I need to do is disable the other three tab pages or tab page forms so that the save process in the edit page must be accomplished from within that page. I wanted to use the Change Event of the Quantity Used control. All the tab page forms are also set to cycle current record.

 

[TheAceMan1]

cpsqlrwn . . .

You need to [blue]consider unbound controls[/blue] for this subform (I see no other options). With your button you can either update the underlying table with an [blue]Update[/blue] query or write the unbound to bound controls with a final [purple]docmd.RunCommand acCmdSaveRecord[/purple]

See Ya! . . . . . .