Form with Combo Box and Button to Open

[MarkV]

I have a Combo Box that has a drop down of Project Numbers. The user must drop down and go to a project number. However if they hit the button without putting a value in the combo box, and hits the open button, it gives me all these screens that pop up. How can I put a MSGBOX or something, that wont allow them to just hit the button without entering a value in the combo box. And the mistake screens don't come up. Thank you. Hope you understand...LOL...
Best Regards...Mark

[CJ_London]

something like

if isnull(combobox) then
    msgbox "must select a project number"
Else
    ....
    your code here
end if

[orange]

I would just add to Ajax's post, that this could be done in the Click event of the button.

[Missinglinq]

Am I missing something, here? This kind of thing is usually done with the code to go to a given project in the AfterUpdate event of the Combobox...if nothing is selected, nothing happens...including error messages!

Linq ;0)>

[orange]

Linq,

Agreed, but if OP needs the combo to be valued and wants to prevent a number of forms to be opened based on the button click. Checking the button click seems reasonable, especially since user is able to Click the button without making a combo selection.

[MarkV]

Thank YOU so much!!!!!!!!!!!!!!!! Gonna Try

Best Mark

[MarkV]

Thank you so much