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
|
|||
|
|||
Hide Sub-form Record Selection Arrows
I have a form containing two Sub-forms, so you see three Record Selection
Arrows. How do I hide the Record Selection Arrows in the Sub-Forms? |
#2
|
|||
|
|||
Hide Sub-form Record Selection Arrows
Open the form in design view, open the properties sheet, go to the format tab
and set the navigation buttons property to "No" HTH "Charles" wrote: I have a form containing two Sub-forms, so you see three Record Selection Arrows. How do I hide the Record Selection Arrows in the Sub-Forms? |
#3
|
|||
|
|||
Hide Sub-form Record Selection Arrows
If you want to display only the navigation buttons for the active object, you
can use the Enter and Exit events of the subform controls. Start with the Navigation Buttons in design view set to Yes for the main form and No for the sub forms. Here is an example: '--------------------------------------------------------------------------------------- ' Procedure : fsubCharges_Enter ' DateTime : 7/24/2007 11:00 ' Author : Dave Hargis ' Purpose : Show sub form navigation buttons and hide parent form navigation buttons '--------------------------------------------------------------------------------------- ' Private Sub fsubCharges_Enter() On Error GoTo fsubCharges_Enter_Error If Me.Dirty Then Me.Dirty = False End If Me!fsubCharges.Form.NavigationButtons = True Me.NavigationButtons = False fsubCharges_Enter_Exit: On Error GoTo 0 Exit Sub fsubCharges_Enter_Error: MsgBox "Error " & Err.Number & " (" & Err.Description & _ ") in procedure fsubCharges_Enter of VBA Document Form_frmContract" GoTo fsubCharges_Enter_Exit End Sub '--------------------------------------------------------------------------------------- ' Procedure : fsubCharges_Exit ' DateTime : 7/24/2007 11:00 ' Author : Dave Hargis ' Purpose : Show Parent form navigation buttons and hide sub form navigation buttons '--------------------------------------------------------------------------------------- ' Private Sub fsubCharges_Exit(Cancel As Integer) On Error GoTo fsubCharges_Exit_Error Me!fsubCharges.Form.NavigationButtons = False Me.NavigationButtons = True fsubCharges_Exit_Exit: On Error GoTo 0 Exit Sub fsubCharges_Exit_Error: MsgBox "Error " & Err.Number & " (" & Err.Description & _ ") in procedure fsubCharges_Exit of VBA Document Form_frmContract" GoTo fsubCharges_Exit_Exit End Sub -- Dave Hargis, Microsoft Access MVP "Charles" wrote: I have a form containing two Sub-forms, so you see three Record Selection Arrows. How do I hide the Record Selection Arrows in the Sub-Forms? |
#4
|
|||
|
|||
Hide Sub-form Record Selection Arrows
On Mon, 17 Sep 2007 08:46:02 -0700, Charles
wrote: I have a form containing two Sub-forms, so you see three Record Selection Arrows. How do I hide the Record Selection Arrows in the Sub-Forms? Open the Form in design view and view its Properties. Set the "Navigation Buttons" property to No. John W. Vinson [MVP] |
#5
|
|||
|
|||
Hide Sub-form Record Selection Arrows
Charles, everyone misread your request. It had nothing to do with navigation
buttons. In design view for each subform, on the property sheet FORMAT tab, set 'Record Selectors' = NO. UpRider "Charles" wrote in message ... I have a form containing two Sub-forms, so you see three Record Selection Arrows. How do I hide the Record Selection Arrows in the Sub-Forms? |
#6
|
|||
|
|||
Hide Sub-form Record Selection Arrows
Thanks for all the help, everyone.
Problem solved. "UpRider" wrote: Charles, everyone misread your request. It had nothing to do with navigation buttons. In design view for each subform, on the property sheet FORMAT tab, set 'Record Selectors' = NO. UpRider "Charles" wrote in message ... I have a form containing two Sub-forms, so you see three Record Selection Arrows. How do I hide the Record Selection Arrows in the Sub-Forms? |
Thread Tools | |
Display Modes | |
|
|