can you use a combo box to jump from form to form?

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

I have a number of Forms (5 to be exact) and I was
wondering if there is a way to jump from form to form
using a combo box. I am currently using command buttons
but they seem to make the form look clunky and out of
date, no matter what I do to them. If you can't use a
combo box I would appreciate any other ideas.

I could really use the help,
Thank you,
Antonio
 
Sure. The following example assumes that the combo box has two columns, the
first, bound column contains the name of the form and is hidden (width set
to zero), the second contains a user-friendly description of the form ...

Private Sub Combo2_BeforeUpdate(Cancel As Integer)

'Make sure the combo isn't empty.
If Len(Me!Combo2.Value & vbNullString) > 0 Then
DoCmd.OpenForm Me!Combo2.Value
End If

End Sub
 
Back
Top