Switching to Design view - lost the icon

  • Thread starter Thread starter Breezy
  • Start date Start date
B

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?
 
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
 
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
 
Back
Top