Trimming navigation bars from subforms

[sal]

I have seen a number of posts online regarding removing navigation bars from subforms, but the straightforward solution is not working for me. I am having an additional problem, with no "navigation" property on my subform property sheet.

I select the subform tool from the toolbar, create an unbound subform and link a query that gives totals for the linked record in the main form. Having done this before in Access 2003, I then select the form and open the subform property sheet but the is no navigation property...

 

[wiklendt]

I have seen a number of posts online regarding removing navigation bars from subforms, but the straightforward solution is not working for me. I am having an additional problem, with no "navigation" property on my subform property sheet.

I select the subform tool from the toolbar, create an unbound subform and link a query that gives totals for the linked record in the main form. Having done this before in Access 2003, I then select the form and open the subform property sheet but the is no navigation property...

are you sure you are selecting the subform itself, and not the subform control?

 

[Mr. B]

wiklendt it right on. It sound like you are selecting the subform control that you see in you main form instead of selecting the "sub form" itself. Although it is possible to actually select the "sub form" and set the properties for it from within your main form, try the method below.

A "sub form" is just like any other form until it is added to another form. It then becomes a subform. With that in mind, locate the "sub form" in the list of all of your other forms and open it in design view. With the form selected, you will see the Navigation Buttons property and you will be able to set it to "No".

 

[sal]

Yes, when I first created the subform by linking an unbound object to my query, Access did not create a form so there was no properties page except that which belonged to the control.

When I used the wizard, Access did create the form and I was able to remove the navigation bars.

Thank you.