Open Form Button

  • Thread starter Thread starter Byron
  • Start date Start date
B

Byron

Larry,
One suggestion for doing what you are wanting to do is to
use a Select Case statement. Take a look in the help file
for more info on using this. Below is some code that you
could use:

Select Case Me.NameOfYourTextBox

Case "inv"
'open the Inventory form
Docmd.OpenForm "Inventory"
case "rep"
'open the Repair form
Docmd.OpenForm "Repair"
case else
'open some other form
Docmd.OpenForm "Menu"
End Select

I do have a question. Why not just create a button for
each of the opportunities that your users have. Each
button having a caption to indicate where the User would
be going?

Byron
 
Back
Top