how do I open a form from a combo box (1 Viewer)

[chewy]

I just want the user to choose which branch location from a combo box and have the shosen location open the corresponding form. Any ideas?

 

[Rob.Mills]

If the entries in the combobox are the same as the names of your forms...

In the AfterUpdate event of the combo box try this:

Dim strForm as string

strForm=Me!Combobox

docmd.openform strForm

 

[Jack Cowley]

You can do this with a Select Case statement but you do not give enough detail of what you want to do. You would, generally speaking, have one form that displayed many branches so you would open the form and display the data about that branch with code similar to this:

DoCmd.OpenForm "FormName", , , "[BranchID] = " & Me.BranchID

If you have a form for each branch then you might want to rethink your approach...

hth,
Jack

 

[chewy]

im still designing it so any ideas would be great!

 

[Hayley Baxter]

Graham posted a good example of this. You can find it in this post.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32254&highlight=search

HTH
Hay