Dropdown list in a form allow editing

[Alan T]

I got a form, actually it is a sub-form links to a table.
I defined one of the field as combobox links to a lookup table. I can select
the item in the dropdown list and save it to a table.
However, I would like to allow the user edit the content of the selected
item, only to edit it and then save to the table but not edit the look up
table.

I can edit the selected item but cannot save it as Access popped up an error
box that I need to select the item from the list.

How do I make the use can edit the item content in the combobox?

 

[Carl Rapson]

Change the Limit To List property of the combo box to No.

Carl Rapson

 

[Mr. B]

I got a form, actually it is a sub-form links to a table.
I defined one of the field as combobox links to a lookup table. I can select
the item in the dropdown list and save it to a table.
However, I would like to allow the user edit the content of the selected
item, only to edit it and then save to the table but not edit the look up
table.

I can edit the selected item but cannot save it as Access popped up an error
box that I need to select the item from the list.

How do I make the use can edit the item content in the combobox?

Alan T,

You have the property "Limit to List" set to "yes" for your combo box.
If you want to limit the selection of items from the list to having to
be in the list, then you will have to have code that adds the new
(edited value) to the list as edited. Otherwise you will continue to
get the message. You indicate that you do not want to add the value
to the lookup table. Normally the primary reason for using a combo
box is to provide user with valid choices for data entry. If you do
not add the edited value to the list of acceptable values then you are
defeating the purpose of the "Limit to List" property. You might as
well set this property to "no" then your users can select something
from the list and make changes to that value and that value is the
value that will be saved in the table the data is being written to.

Hope this helps.

Mr. B

 

[Alan T]

HI,

I double checked that the Limit to List is already set to 'No'.

Any more idea?

 

[Alan T]

Sorry for my mistake.
Yes, the Limit to List is 'No' and it works.
And is it possible to move the column to another position on the datasheet
view?
At the moment the column is at the last and I want to move to the second
position.

 

[Carl Rapson]

The order of the columns on the datasheet view should be the same as their
order in the underlying Record Source. Change the order there, and the order
on the datasheet should change.

Carl Rapson

Sorry for my mistake.
Yes, the Limit to List is 'No' and it works.
And is it possible to move the column to another position on the datasheet
view?
At the moment the column is at the last and I want to move to the second
position.

<snipped>