Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for code that would allow me to make a selection from a drop
down box (combo box) and based on that selection it closes that form and
opens another form based on that selection.
 
Try this in the "AfterUpdate" event...

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "FormName"

stLinkCriteria = "[frmID]=" & Me![frmID]
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria

This is what I always use.

- Paul
 
In the After Update event of the combo box (called cmbFind in my example) try
this.
It also assumes the content selected in the combo box will give a unique
record for the other form.

Application.Echo False
DoCmd.OpenForm "OtherForm"
DoCmd.FindRecord cmbFind.Column(0), acEntire, , acSearchAll, , acAll, True
DoCmd.Close acForm, "ThisForm", acSaveNo
Application.Echo True
 
You must log in or register to reply here.

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 box filter 1
return value based on combo box selection 3
connecting combo boxes 1
Combo Box Question 4
combo box search field problem on form 1
how to show data only from selected combo boxes ? 0
Mult-Value Select returning ID# not text. 4
Combo Box and First Record 5

Back
Top