Hi,
I have developed an Access graph chart displaying data statistics. The chart is embedded as a subform in the main form where users select a value from a drop-down combo box (it is on the main form) to generate the graph.
The issue is when the database is set up on user's computer, they can drop down the list of the combo box and scroll but can not select the contents. This does not happen when I developed the chart.
I was skeptical about 1) Window's security setting for files, and 2) the Default open mode in Access' Tools/Options/Advanced tab. However, I poked around with window's security for the database file and switched the Default open mode between Shared and Exclusive, the outcome is still mystic. It works on some users but not others.
Anyone out there has a better idea of what is going on with the combo box here? Your help is greatly appreciated.
Regards.
I have developed an Access graph chart displaying data statistics. The chart is embedded as a subform in the main form where users select a value from a drop-down combo box (it is on the main form) to generate the graph.
The issue is when the database is set up on user's computer, they can drop down the list of the combo box and scroll but can not select the contents. This does not happen when I developed the chart.
I was skeptical about 1) Window's security setting for files, and 2) the Default open mode in Access' Tools/Options/Advanced tab. However, I poked around with window's security for the database file and switched the Default open mode between Shared and Exclusive, the outcome is still mystic. It works on some users but not others.
Anyone out there has a better idea of what is going on with the combo box here? Your help is greatly appreciated.
Regards.
