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

 

[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