List box to choose which form to open

[MFS]

Wanting the user to choose a form in a list box and then it opens after they click a command button.


Can someone help me with this?

Thnx,

Mike

[ranman256]

I have a table that holds the list of user choices..
[Caption]
[Target]

The caption lets the user see CLIENTS, but the table is tClients
It works for any object: queries, reports, etc
all my tables start with t, all forms start with f, all reports start wth r, queries start wth q., macros start wth m
the user selects the combo box value
picks CLIENTS, but the combo bound column = 2 so the value of cboPick = tClients.
the cboPick_Afterupdate() code determines which vb statement to use:

if not isnull(cboPick) then
case select left(cboPick,1)
    case "t"
      docmd.openTable cboPick
    case "f"
      docmd.openForm cboPick
    case "q"
      docmd.openQuery cboPick
    case "r"
      docmd.openReport cboPick
    case "m"
      docmd.runMacro cboPick
end select
endif

[MFS]

Ahh, This helps me greatly,
Thank You ranman256