I am using a List Box 1 to limit the query beneath a another List Box 2. The Form is unbound; the List Box 1 is unbound and populated by a Value List; "Enable" is True, "Locked" is False.
In Design view, I can't make my selection in List Box 1. Using VBA control events to troubleshoot, I find that AfterUpdate and Click do not happen. GotFocus however does.
In lieu of List Box 1, I am happy with a Combo Box or Option Group (my original choice). Same problem with all three types of control. For example, with radio buttons in an Opt.Group, they appear dimmed.
No issues with "enabled" or "locked" as far as I can tell. I've tried building these controls with and without wizard. AND I AM VERY FRUSTRATED. (Sorry -- that slipped out.)
_______________________________
Never confuse movement with action -- E. Hemingway
_______________________________