Is it possible to make list box selection in a no edit form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a project data base where users can view project details in a
form that does not allow editing (AllowEdit set to no). At the same time I
want to place a list box in the form where users can scroll through a list of
all projects. The list box is using a few fields from the main table.
However, if the form's AllowEdit is set to no, it does not seems possible to
make selections in the list box. Any way to work around this?
Niels
 
I am developing a project data base where users can view project details in a
form that does not allow editing (AllowEdit set to no). At the same time I
want to place a list box in the form where users can scroll through a list of
all projects. The list box is using a few fields from the main table.
However, if the form's AllowEdit is set to no, it does not seems possible to
make selections in the list box. Any way to work around this?
Niels
Click to expand...

Make the listbox Unbound - set its Control Source to blank. Then
you'll be able to select a value (given that Access realizes you're
not trying to update the bound column).

John W. Vinson[MVP]
 
Thanks John.
It does not help although the control source is blank. However, column 1 is
bound and if I try try to set it to blank I get an error message.
So, I still can't select in the box.
Niels
 
Thanks John.
It does not help although the control source is blank. However, column 1 is
bound and if I try try to set it to blank I get an error message.
So, I still can't select in the box.
Niels
Click to expand...

You may need to allow edits on the Form, and simply set all the
controls *other* than this listbox to Enabled = No, Locked = Yes.

John W. Vinson[MVP]
 
Back
Top