force action at combo box

[markjkubicki]

I have code that requiries, sets focus to, and then displays the drop-down for a combobox.


All of this is because I simply do not want the cbo displayed all of the time...
The sub that executes this code is triggered by a command button, and is intended to check to see if the user has any history "changing projects", and if so, the user can simply pick from the cbo which is self populating; if there is no history then code executes a file dialogue for them to pick from...

The problem is... after the dropdown appears, the code continues to execute...

What I would like it to do is stop executing code until the owner takes an action in the cbo. The cbo has its own code that will execute on its after-update event, and once that has happened, the remainder of the code in the sub that displayed the cbo should continue


I think what I may have to do is put the cbo on an unlinked subform, and them make the form modal;
I was hoping that there might be a more direct (ie: simpler) method

Private Sub cmdChangeProject_Click()
vCnt = DCount("[ProjectName]", "tblChangeProjectList")
If vCnt > 0 Then
Me.cboChangeProject.Requery
Me.cboChangeProject.Visible = True
Me.cboChangeProject.SetFocus
Me.cboChangeProject.Dropdown
Else
...

any thougths are appreciated with thanks in advance
Mark

[June7]

What is the remainder of the code? It couldn't be in the AfterUpdate event? Otherwise, would have to put combobox on popup form, not a subform, and that presents issue of how to pass value back to the calling form.