How to use an unbound dropdown?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

escoz - 19 Apr 2007 19:03 GMT

Hi guys,

I have a dropdown on an Access Form, with its RowSourceType =
ValueList, RowSource = "1;2;3", and ControlSource = "" (empty).

The value selected by the user will be used only by a VBA script; I
don't want to have it bound to anything.

The control works, it display the list correctly, but I just can't
select any item!! It doesn't seem to be firing any events either!

I would really appreciate any help! I couldn't find any information
online on how to use an unbound dropdown.

Thanks!!

Eduardo Scoz

Reply to this Message

SusanV - 19 Apr 2007 19:46 GMT

To be able to select it, you have to allow edits is the properties of the
control. To keep users from changing or adding to your values, set the limit
to list to yes. Use the OnChange or After Update events to fire your code.

Signature

hth,
SusanV

> Hi guys,
>
[quoted text clipped - 13 lines]
>
> Eduardo Scoz

Reply to this Message

escoz - 19 Apr 2007 20:10 GMT

> To be able to select it, you have to allow edits is the properties of the
> control. To keep users from changing or adding to your values, set the limit
[quoted text clipped - 20 lines]
>
> > Eduardo Scoz

Hi SusanV,

Thanks a lot! I found the "allow edits" as a property of the form, not
the control. It worked!

Thanks a lot for helping!

Regards,

Eduardo

Reply to this Message

SusanV - 20 Apr 2007 13:11 GMT

Glad to help!

>> To be able to select it, you have to allow edits is the properties of the
>> control. To keep users from changing or adding to your values, set the
[quoted text clipped - 33 lines]
>
> Eduardo

Reply to this Message