Menu Screens and Dropdown options

[monkeytunes]

Oh, buddays.

I have a hefty database with a series of full-size forms which act as navigational menus. The VicePrez has asked for some dropdown menus which will further open particular forms (to cut back on the number of buttons per screen).

I tried using the combo-box dropdown wizard to put a dropdown list on "frmMainMenu" with my own values entered, which I then applied to some VB code like this:

Private Sub drpProjectMenu_AfterUpdate()
If Me.drpProjectMenu.Value = "Open All Projects" Then
DoCmd.OpenForm ("frmProjectFormAll")
ElseIf Me.drpProjectMenu.Value = "Open Projects by Project#" Then
DoCmd.OpenForm ("frmProjectFormByProjectNo")
ElseIf Me.drpProjectMenu.Value = "Open Projects by Manager" Then
DoCmd.OpenForm ("frmProjectFormByManager")
Else
DoCmd.OpenForm ("frmMainMenu")
End If

End Sub

Of course, none of this works (or else I wouldn't be posting).

Dropdowns have always kind of mystified me, and this one is no different - While my values show up just fine in the dropdown, navigating to one of them and clicking it does nothing; the dropdown remains blank. Hence, my VB code doesn't even get triggered, let alone execute. (I'm sure when/if I do manage to trigger it, I'll find plenty more problems.)

After searching around the forum, I suspect I might be completely on the wrong track. I also suspect that the answer is something ridiculously easy and obvious, and I should just wear a big cap that says "clueless n00b".

Many thanks if you point me in the right direction! (Examples would be outta-sight-good, too...hint hint)

-monkey

 

[___]

See if this helps

 

[maxmangion]

i used the following and works fine for me but i am not sure if it is the right method. check here

 

[monkeytunes]

Hey Maxmangion, I like your menus, although I think I'm more inclined to follow ____'s lead as I was already trying to use dropdown combo-boxes. I can see where the mouseover might be useful in other places, so thanks!

Hey ____, how would the code change if, instead of form names for the values in the combo box, you wanted to use common names that end users can understand (like, say, "Form 1" but meaning "frmOne") ? I'm a TOTAL VB newbie, and while I can usually understand what's going on when I see finished code, producing it from scratch puts me at a complete loss. Would it be something like the code I posted above? Thanks!

-monkey

 

[___]

Something like this?

 

[monkeytunes]

Hey ____, that's exactly what I was looking for w/r/t the menus - the removal of the "Go" button, however, has already raised some serious discussion around the office. Make the menus automatic...or make the user consciously accept the dropdown? Oooooooooh, what to do, what to do?

Thanks!

 

[PierreR]

Title line for drop-down box.

How does one put a description for the kind of forms to open inside the undropped drop-down box instead of using a label; meaning it must show before and when it has received the focus and before the choice is made?

 

[___]

the removal of the "Go" button, however, has already raised some serious discussion around the office.

Attached is another option, just to confuse the issue

 

[___]

How does one put a description for the kind of forms to open inside the undropped drop-down box instead of using a label; meaning it must show before and when it has received the focus and before the choice is made?

Here's a simple solution, I think it's what you mean.

 

[PierreR]

Like label

No, that is not what I meant. What I meant is I want a description of the type of elements inside the combobox before you even get to the combobox.

It must look like a label with a descriptive string inside it, before you drop it down.

People often cannot understand me. I must have a unique kind of brain, like everyone else.

 

[monkeytunes]

Attached is another option, just to confuse the issue

OH! The dreaded confirm box!!! NOBODY here likes THAT.

Man, nothing frustrates me more throughout the day than the constant confirmation my computer asks from me. I click "SEND" and my computer asks "Are you sure you want to send?" I click "Log Out" and my computer asks "Are you sure you want to Log Out?"

OF COURSE I'M SURE! If my computer was in the military, it'd be doing push-ups every other minute for insubordination. QUIT QUESTIONING MY AUTHORITY, COMPUTER!

Seriously, there's only ONE place where I like the confirm, and that's when I haven't saved something. ANYWHERE else and it's infuriating.

​

 

[monkeytunes]

No, that is not what I meant. What I meant is I want a description of the type of elements inside the combobox before you even get to the combobox.

It must look like a label with a descriptive string inside it, before you drop it down.

People often cannot understand me. I must have a unique kind of brain, like everyone else.

This isn't very elegant, but is THIS what you meant? And if it is, then I'm sure ____ can find a better way to implement it, especially without triggering the VB code. All I did was put "Choose an option" in the Default Value property, as well as part of the Row Source. I've started to do this if I have several screens of menus - I'll put the top choice as the next menu screen, but all of THAT screen's options are also in the first screen's dropdown.

 

[PierreR]

Too big a wrench.

okay monkeytunes. That is what I wanted but something else went wrong, because now the drop-down doesn't work anymore. I'll try and see what it is.

 

[___]

Ahhh....thats what you meant
Here you go.

 

[___]

Just one more thought, you could also use the MouseMove event to change the Forms caption.