Forum Discussion
Solved
Hide Navigation Buttons on Linked Table
Hi I have a parent form with a linked child table which all works fine but I want to hide the navigation buttons on the linked table. I know the VBA code for hiding the buttons but the only even...
- Karl and Arnel are quicker.
While it is possible to simply embed a table directly in a subform control, you lose the ability to manage it as effectively as when you use a form in a subform control. In this case, for example, you lose the ability to hide Navigation buttons. Sometimes, in the early stages of learning Access, we find things that seem handy (like embedding a table in a subform control), but which turn out not to be the most appropriate or effective or flexible approach. The key is to keep an open mind and continue refining your tool kit as you gain more experience.
Hi George, thanks for the reply. I should say I'm no Access expert. I referred to it as a linked child because of the entries you have pointed to in the data tab. Anyway, here's the screenshot which shows the navigation buttons for the table which are the ones I want to hide.
Design View shows the Table like this:
The navigation button property only applies to the main form. The are no navigation button options for the table.
Karl and Arnel are quicker.
While it is possible to simply embed a table directly in a subform control, you lose the ability to manage it as effectively as when you use a form in a subform control. In this case, for example, you lose the ability to hide Navigation buttons. Sometimes, in the early stages of learning Access, we find things that seem handy (like embedding a table in a subform control), but which turn out not to be the most appropriate or effective or flexible approach. The key is to keep an open mind and continue refining your tool kit as you gain more experience.
While it is possible to simply embed a table directly in a subform control, you lose the ability to manage it as effectively as when you use a form in a subform control. In this case, for example, you lose the ability to hide Navigation buttons. Sometimes, in the early stages of learning Access, we find things that seem handy (like embedding a table in a subform control), but which turn out not to be the most appropriate or effective or flexible approach. The key is to keep an open mind and continue refining your tool kit as you gain more experience.
Thanks to you all for your answers. I chose to remove the embedded table and insert a subform for which I now have the controls I need.