ridiculously easy question about lists

[sagey]

i have created a form with a listbox
my question is how do i stop the selection from being editable
(ie when something on thelist is selected it is selected and you can delete the word or edit it)

i know this must be doable by simp[ly changing a listbox property but im not sure which one

cheers

 

[Fizzio]

Make sure that Locked = Yes (In Data)

 

[kato68]

I am having the opposite problem. I can't edit the values. I have the locked property set to 'no'. I can change which record is highlighted but I cannot change any of the data. And I have enabled set to 'yes'.

 

[Pat Hartman]

Is the listbox bound to a field in the form's recordsource?
Is the listbox set for single select?

 

[kato68]

I have it bound to an ID number, and it is set for single select.

 

[Pat Hartman]

Is the form's query updateable when you open it by itself?

 

[kato68]

I have it running off of a table. Should I have it running off a query instead?

 

[Pat Hartman]

Forms should always be based on queries with where clauses rather than tables. This gives you better control over the recordsource and reduces the amount of data requested from the server if your tables are ODBC data sources.

Using a table as the recordsource would not make the form not updateable. Is any field on the form updateable? Can you update the table.?