dbTalk Databases Forums  

Can't Move Between Records with Navigation Buttons

comp.database.ms-access comp.database.ms-access


Discuss Can't Move Between Records with Navigation Buttons in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hi
 
Posts: n/a

Default Can't Move Between Records with Navigation Buttons - 02-02-2004 , 09:57 PM






Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm running Access XP,
thanks for any help.

Reply With Quote
  #2  
Old   
Bruce Pick
 
Posts: n/a

Default Re: Can't Move Between Records with Navigation Buttons - 02-03-2004 , 07:58 AM






Check the form's data source. I expect you're using a query with has
the same characteristics. If you can't add records or modify in the
source, you can't do it directly in the form either.

This is a "Non-Updatable" query. Usually caused by using grouping
functions, or by using multiple tables joined in such a way that records
cannot be updated or added.

Bruce Pick

hi wrote:

Quote:
Hi,
I've created a form, on the bottom it has the navigation buttons to move to
the next/previous records. However, the button for "new record" is greyed
out (i can't select it). How do I make the "new record" button visible so
I can select it? No matter what I do (Records->Save Records) it won't save
this record and allow me to enter another record. I'm running Access XP,
thanks for any help.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.