Remove navigation buttons on subform

[ADixon]

Hi all

I have a subform based on a query. I can't seem to find any way of removing
the navigation buttons and disabling deletion and addition. Usually, (when
the subform is based on a table) this is a property of the subform. Any one
have any ideas why this is happening as i'm tearing the last of my hair out.

Thanks

 

[Dirk Goldgar]

Hi all

I have a subform based on a query. I can't seem to find any way of
removing
the navigation buttons and disabling deletion and addition. Usually, (when
the subform is based on a table) this is a property of the subform. Any
one
have any ideas why this is happening as i'm tearing the last of my hair
out.

I suspect that you've set the subform control's Source Object property
directly to the query, rather than creating a form object based on the query
and setting the Source Object to that form object. If you want to be able
to control the NavigationButtons, AllowAdditions, and AllowDeletions
properties, you must use a form as the subform control's Source Object.

Create a form based on the query -- you can set its default view to
Datasheet View if you want -- and set your subform control's SourceObject
property to that form.

 

[Lu]

ADixion do this:-

1. open sub form in design mode
2. open properties
3. on format tab set 'Navigation Buttons' to No (you can reset this later
agin)
4. an then go to Data tab, set 'Allow Deletions' and 'Allow Additions' to No

I think and hope this will assist.

 

[ADixon]

Dirk

Thanks for this solution, it works perfectly. Users are now restricted as
desired.

Regards