How to use an unbound dropdown?

[escoz]

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

 

[SusanV]

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.

 

[escoz]

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.

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

 

[SusanV]

Glad to help!

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