Switching to Design view - lost the icon

[Breezy]

I have somehow lost the toolbar / icon to switch to design view. I need to
make some changes and I'm not sure how to get back to the design view without
the toolbar option.

ALso... I need to make a field become required only if another field is
checked. I have a field that says completed with a check box option. When
this is selected, I want the work order field to become required. How do I do
this?

 

[Graham Mandeno]

Hi Breezy

Is your form modal or popup? Both these will prevent the toolbar from
changing to match the context of the form.

However, you should be able to right-click on the form's background and
choose "Form design" from the context menu.

I suggest you use your form's BeforeUpdate event for validation based on
multiple fields:

If Me.chkCompleted And IsNull(Me.txtWorkOrder) Then
Me.txtWorkOrder.SetFocus
MsgBox "Please supply a work order"
Cancel = True
End If

 

[Graham Mandeno]

Hi Breezy

Is your form modal or popup? Both these will prevent the toolbar from
changing to match the context of the form.

However, you should be able to right-click on the form's background and
choose "Form design" from the context menu.

I suggest you use your form's BeforeUpdate event for validation based on
multiple fields:

If Me.chkCompleted And IsNull(Me.txtWorkOrder) Then
Me.txtWorkOrder.SetFocus
MsgBox "Please supply a work order"
Cancel = True
End If