A tricky question. In Acc2000 I've got a combobox control on a continuous subform which refreshes on the OnClick event so that the user can select a value for that row from a small number of choices. Often/usually there is only one choice, so my users have the unentertaining task of clicking on every record just to be able to stick that value into that row. I want to improve that before they all get RSI. If the combo box only offers one choice for a particular row, then I need that value to be auto-selected and auto-entered without a click event.
My first approach is to set the default value of the combobox to the first record of its control source i.e. DefaultValue = [cboName].[itemData](0). This doesn't work, but I'm not sure why.
Can anyone suggest a method that might work, or tell me what I might be doing wrong in the 'DefaultValue' method?
My first approach is to set the default value of the combobox to the first record of its control source i.e. DefaultValue = [cboName].[itemData](0). This doesn't work, but I'm not sure why.
Can anyone suggest a method that might work, or tell me what I might be doing wrong in the 'DefaultValue' method?
Last edited:
