can't move to new record in my form

[janedevo]

I am doing pretty well with Access and have never had this come up before. At the bottom where you can click to go to new record...that button is greyed out, therefore i cannot go forward. I know this is very simple. The 'allow adds, deletes and edits' are all checked yes on my properties. Thanks for your help! ~j

 

[arifmasum]

I am doing pretty well with Access and have never had this come up before. At the bottom where you can click to go to new record...that button is greyed out, therefore i cannot go forward. I know this is very simple. The 'allow adds, deletes and edits' are all checked yes on my properties. Thanks for your help! ~j

Are you showing your values in the form? If it direct from table you can add, if from query, i think you can not add..

 

[rainman89]

Are you showing your values in the form? If it direct from table you can add, if from query, i think you can not add..

almost correct, you have to make sure your query is an updatable one. if it is then you can add.

 

[burrcm]

Your table must have a primary key.

Chris B

 

[missinglinq]

Your table must have a primary key.

Chris B

Simply not true; where did that come from?

As Rainman89 said, some queries are updatable and some aren't! From the facts you've given, it would appear that your form is based on a query. A simple test would be to open the query and see if you can add a record to it. Allen Browne, the "Wonder from Down Under," gives a very good explanation of this phenomenon as well as possible workarounds.

http://allenbrowne.com/ser-61.html

Good Luck!

Linq

 

[burrcm]

Indeed it is not. Sorry. Applies when linked to external tables - informix etc.

Chris B