Open Form Based On Combo Box (VBA)

[SamDemon]

Good afternoon,

Does anyone know what the best way is to code a combo box (AfterUpdate) on a form to open a new form on a specific record.

I have created a query with the following fields.

tblBooking.BK_ID
tblBookingPP.PP_ID
tblBookingPP.PNR

The form that I will be using is frmFindPNR and the result form the combo box on the form will need to open frmBooking on the tblBooking.BK_ID which corolates to the tblBookingPP.PNR

Once the new form is open the frmFindPNR should close.

ie

tblBooking.BK_ID tblBookingPP.PP_ID tblBookingPP.PNR
1 3 ABC123
2 7 CDE456
3 8 GHI789

if the user selects ABC123 from the combo box frmBooking would open with BK_ID - 1

Any advice would be greatfully received (with a star!!)

Thanks

Sam

It's just common sense, shame sense isn't common!

 

[PHV]

What have YOU tried so far and when in YOUR code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SamDemon]

PHV - I have SORTED this now! But thank YOU for ALL your help #sarcasm

It's just common sense, shame sense isn't common!

 

[missinglinq]

Glad you've got it working, Sam!

Forum etiquette on all sites like this requires that when a poster solves his own problem, he reports how the situation was resolved! In this way, if someone comes to the site, searching for help with a similar problem, they can learn what worked for you! And you're on your way from being a student to being a teacher!

The Missinglinq

Richmond, Virginia

The Devil's in the Details!