List Box in Access 2007 Form

[Gucci2006]

I am able to retrieve a record using a list box in a form. However, I am unable to make changes in the form so that the under-lying table is updated.

I get an error message in the bottom left hand corner of my screen that says....

"Recordset is not updatable"

Any Help would be greatly appreciated!

 

[Remou]

You may wish to read:

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

 

[fneily]

Is your form based on a query? See:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

Or if it's just a table, do you have the primary key on the form?

 

[Gucci2006]

This form is not using a query. It is linked to a table. The form does include the primary key!

 

[fneily]

Show the code you have on the listbox to filter the table.