Entering info to forms

[Howlsta]

I've built a form based on a query. I want to enter information into the form but when i try i get a beep and recordset not updateable. I checked the properties and everything seems to be okay. I reckon it might be to do with the table the query is based on or something. Any ideas, please??

 

[D-Fresh]

That probably just means that your query is not updatable.. To check this, open up your query and look at the navigation buttons.. If the new record( >* ) button is grayed out, then the recordset is not updatable. Hope this helps.

Doug

 

[Howlsta]

It's greyed out allright. I think it's because i've got an expression in one of my columns which calls the array. Does this mean i have to call the array from the form or can I get rid of this un-updateable some other way?

Rich

 

[Pat Hartman]

Queries can be not updateable for a varity of reasons. You can find a paper on this at the Microsoft download site. There is much information on the topic in help but you need to be persistant and creative to get to it.

Some of the reasons are:
The query contains a join and the key fields are not included.
The query contains an aggregate function.
The unterlying table or tables do not contain unique indexes.
The query contains a group by clause.

Having a calculated column will not necessarily make the query not updateable.

If none of those things apply, post the query and perhaps someone will spot something.

 

[cargobay 69]

...and if all else fails, there is detailed information about this problem in your Access Help files. Look up the topic (or ask your Office Assistant) "When can I update data from a query?".

I'm using Access 97 so other versions may be a little different.

Darrin - CB69