If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switching to Design view - lost the icon
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? |
#2
|
|||
|
|||
Switching to Design view - lost the icon
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 -- Good Luck :-) Graham Mandeno [Access MVP] Auckland, New Zealand "Breezy" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|