Share via

How To Disable Navigation Bar Buttons On A Sub-Form Based on Query Table Source?

Anonymous
2011-02-09T15:23:49+00:00

Hello, I found something interesting, seems very easy, but couldn't figured out..

I Put a Sub-form on my form, based on Query Table Source, it has it's own navigation buttons which i don't want, I couldn't find any option of disabling it, because it doesn't have! Very Strange why... There must be another solution of disabling it by VBA or something.... (If Sub-Form is based on form source it is possible to disable Navigation Buttons).....

Also it inserts empty rows and columns....

What I mus Do?

Thank You In Advanced

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-02-09T16:49:30+00:00

    There are very few options for how a query's datasheet should look and Nav buttons is not one of those few.  Use a real form as a subform (with its record source set to the query) and set the form's NavigationButtons property to No.

    The NavigationButtons property is a property of a form object, it is not a property of a subform control that is used to display a query's datasheet or a form object.

    It sounds like you clicked once on the subform control in the main form's design view.  If you click a second time, you should then be in the form.  To get to the form object in the subform control, click on the little box in the subform's upper left corner above and to the left of the design view rulers.

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-12-12T15:27:11+00:00

    Me.Child124.Form.NavigationButtons = False

    Just because you don't know dosn't mean it can't be done learn to think

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2011-02-09T15:35:25+00:00

    If I understand what you're saying about setting a subform control's SourceObject property to a query, then you have decided to let Access make up how it should look.  To get the features of a normal subform, set the SourceObject property to a form object with it's DefaultView set to Datasheet (or Continuous).

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2011-02-09T15:47:49+00:00

    Hello Marshal

    My Sub-Form is based on a Query [Query.QDATA] and The query in design mode doesn't have the option to disable The Navigation bar Buttons....

    When selecting the Sub-Form on My form in Design view there isn't also any option of disabling the nav. buttons.....

    Maybe I need something In VBA?

    I Couldn't Figured out... Seems to strange

    Was this answer helpful?

    0 comments