using a locked combo box to change data

[grzzlo]

Hi Access experts,

I have a subform in datasheet view that has a bound combo box that's based on an expression and can't be updated, but I'd like to let the user edit it. Impossible, right? But the user can still click the dropdown and see the list of options and then click on an option. Of course, Access will just beep at them b/c the field can't be edited. But is there any event that gets triggered when the user clicks on one of the options in the dropdown? Any way to capture their selection and run an update query?

I was hoping the BeforeUpdate event would fire before Access canceled the update, but no luck. Now it appears that the OnClick event doesn't even fire, I can't imagine why not. But MouseDown does. So can I find out what row the user selected when the MouseDown event fires? Or is there another way to do it?

I can give more details if desired, but I'm pretty sure all other details are irrelevant. Let's just say I've got a locked combo box called cboName with a 2-column row source and I want to display a message box with [cboName].[Column](0) when the user clicks on an item in the dropdown. Of course, I don't really want a message box, but it'd be a great start...

Thanks in advance.

 

[grzzlo]

After looking through all the properties associated with comboboxes, I'm pretty sure that there's no way to do what I'm trying to do. I'll probably have to go with an unbound combobox on a continuous form, but I'm hoping to avoid that if possible.

Anyone have any brilliant ideas?