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

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
 
B

Brendan Reynolds \(MVP\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo or list box 0
combo box locked 4
Problem with Combo box on form 1
Combo box to control two sub forms 2
Combo Box Help 7
Form with combo box to set criteria for query and report 2
Filter a form using a combo box and a macro 2
Copy previous record into form field 0

Top