If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Combo box does not react on first click
I have 5 combo boxes on a form and all except one accept the chosen row at
the first click. I am tearing my hair out trying to find why only this one reacts when it is dropped down and the row is clicked for the second time. Please someone show me how stupid I am being. |
#2
|
|||
|
|||
Combo box does not react on first click
Richard -
Could you have used the double-click event for your code instead of the click event? -- Daryl S "RichardGarfield" wrote: I have 5 combo boxes on a form and all except one accept the chosen row at the first click. I am tearing my hair out trying to find why only this one reacts when it is dropped down and the row is clicked for the second time. Please someone show me how stupid I am being. |
#3
|
|||
|
|||
Combo box does not react on first click
Hi Daryl
Thanks for the suggestion. Unfortunately I don't use any click event. On GotFocus it drops down automatically, and then reacts OnUpdate. Richard "Daryl S" wrote: Richard - Could you have used the double-click event for your code instead of the click event? -- Daryl S "RichardGarfield" wrote: I have 5 combo boxes on a form and all except one accept the chosen row at the first click. I am tearing my hair out trying to find why only this one reacts when it is dropped down and the row is clicked for the second time. Please someone show me how stupid I am being. |
#4
|
|||
|
|||
Combo box does not react on first click
Richard -
Does it not highlight on the first click, or does it highlight on the first click but not execute code until the second click? Is this combo box bound to a field in the recordsource? -- Daryl S "RichardGarfield" wrote: Hi Daryl Thanks for the suggestion. Unfortunately I don't use any click event. On GotFocus it drops down automatically, and then reacts OnUpdate. Richard "Daryl S" wrote: Richard - Could you have used the double-click event for your code instead of the click event? -- Daryl S "RichardGarfield" wrote: I have 5 combo boxes on a form and all except one accept the chosen row at the first click. I am tearing my hair out trying to find why only this one reacts when it is dropped down and the row is clicked for the second time. Please someone show me how stupid I am being. |
#5
|
|||
|
|||
Combo box does not react on first click
Hi Daryl
Let me explain. The combobox is bound to a query and drops down on getting focus. When you click on your choice, it closes without showing the choice in the box. AfterUpdate fires with the box blank and it jumps to the next control. When you then return to it, drop it down again and choose, it shows the correct choice. Does that help? Richard "Daryl S" wrote: Richard - Does it not highlight on the first click, or does it highlight on the first click but not execute code until the second click? Is this combo box bound to a field in the recordsource? -- Daryl S "RichardGarfield" wrote: Hi Daryl Thanks for the suggestion. Unfortunately I don't use any click event. On GotFocus it drops down automatically, and then reacts OnUpdate. Richard "Daryl S" wrote: Richard - Could you have used the double-click event for your code instead of the click event? -- Daryl S "RichardGarfield" wrote: I have 5 combo boxes on a form and all except one accept the chosen row at the first click. I am tearing my hair out trying to find why only this one reacts when it is dropped down and the row is clicked for the second time. Please someone show me how stupid I am being. |
#6
|
|||
|
|||
Combo box does not react on first click
Richard -
I'm not sure what is going on. I would suggest adding some debug.print me.combobox.column(0) statements (using your combobox name) in a few places: GetFocus Click AfterUpdate Then put a breakpoint in the top of each of these and see what the value is, the first time through and the second. See where it is changing. If you want to force a value, you can use the AfterUpdate event of the control, and if the value is blank, you can drop down the list again. -- Daryl S "RichardGarfield" wrote: Hi Daryl Let me explain. The combobox is bound to a query and drops down on getting focus. When you click on your choice, it closes without showing the choice in the box. AfterUpdate fires with the box blank and it jumps to the next control. When you then return to it, drop it down again and choose, it shows the correct choice. Does that help? Richard "Daryl S" wrote: Richard - Does it not highlight on the first click, or does it highlight on the first click but not execute code until the second click? Is this combo box bound to a field in the recordsource? -- Daryl S "RichardGarfield" wrote: Hi Daryl Thanks for the suggestion. Unfortunately I don't use any click event. On GotFocus it drops down automatically, and then reacts OnUpdate. Richard "Daryl S" wrote: Richard - Could you have used the double-click event for your code instead of the click event? -- Daryl S "RichardGarfield" wrote: I have 5 combo boxes on a form and all except one accept the chosen row at the first click. I am tearing my hair out trying to find why only this one reacts when it is dropped down and the row is clicked for the second time. Please someone show me how stupid I am being. |
Thread Tools | |
Display Modes | |
|
|