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?

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?

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?

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]

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?

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?