Prevent switching between tabs in Navigation form when task is active

[kets0985]

Hello,



I have a 4 forms in my navigation form. Each form is use to record different task.

I want to prevent users to switch to other tabs when they have a active task in any of the tab.

Means, if they started with the task in one form they should not be able to select or go to other form in navigation form.

Could you please assist me in this case ?

[ranman256]

Try opening the form in modal mode.
docmd.openform "frmEntry",,,,acModal

[nick404]

Click the Windows icon in top left corner, then in bottom right of the menu select Access Options. Go to 'Current Database'.

If you uncheck 'Display Navigation Bar' (towards bottom) the left hand menu consisting of all the db's tables, forms, queries, reports, etc. will not be visible when opened. Further, if you uncheck 'Display Tabbed Docuement' (towards top) the user will not see any of the forms, reports, queries, etc. that they have opened. (Along the top, the tabs will not appear).

If you decide on both these options you will need a fluid database so user does not get stuck somewhere, or cannot access a form or report they need.

[kets0985]

I tried opening the form in modal mode, but it doesn't help.

I have hidden the navigation pane, toolbar, menu bar everything. I have a navigation form, which include 4 subforms which records different set of data.

My problem is, when a start entering the data in 1 subform, then I should not be able to switch the form before I undo the data entry or submit the data to database.

[nick404]

If Me.Dirty then MsgBox "Submit data or reset form to continue"
Exit Sub
End If

Add a reset button to easily allow users to reset the form:
Sub cmdReset_Click()
Me.Undo
End Sub