Drop down list edit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

acss - 31 Mar 2008 18:11 GMT

I have a drop down list on one of my forms that contains description
selections for end users to pick from. The problem is that the field can not
be edited and should a product description change then end user can not key
in correct information. Is it possable to have an editable drop down list?

Reply to this Message

fredg - 31 Mar 2008 19:41 GMT

> I have a drop down list on one of my forms that contains description
> selections for end users to pick from. The problem is that the field can not
> be edited and should a product description change then end user can not key
> in correct information. Is it possable to have an editable drop down list?

What is the rowsource of your combo box?
Table/Query?
All you need do is edit the table (using a form, of course) which is
used as the rowsource of your combo box.

If this isn't the information you need, then you'll need to post back
with more information.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Evi - 31 Mar 2008 23:44 GMT

It's best if you use some NotInList code so that a form opens allowing the
user to edit data. This gives you more control on what the user enters. A
list that can be edited has lost some of its usefulness in ensuring that
data remains uniform.
Evi

Reply to this Message