Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Remove navigation buttons on subform

2,770 views
Skip to first unread message

ADixon

unread,
Jun 22, 2009, 12:16:01 PM6/22/09
to

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

unread,
Jun 22, 2009, 12:29:13 PM6/22/09
to

"ADixon" <ADi...@discussions.microsoft.com> wrote in message
news:BC97534A-4AE4-49C9...@microsoft.com...


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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Lu

unread,
Jun 23, 2009, 4:33:01 AM6/23/09
to

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

unread,
Jun 23, 2009, 5:09:02 AM6/23/09
to

Dirk

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

Regards

0 new messages