Combo box data to open query

[kpryan]

Hi all,

I have a combo box with 2 fields, company and company ID. I want to be able to select a company ID via the combo box to open another form.
saves having to input an ID each time into the query, which opens the form.
Any help much appreciated.

Thanks,

Ken

 

[HandsOnAccess]

You can write a code for Afterupdate Event of the combo box as shown below to open another form...

Private Sub Combo0_AfterUpdate()
DoCmd.OpenForm "Company", , , "[Company ID] = " & Me.ActiveControl.Column(0)
End Sub