Opening a form via combobox in a subfrm

[soundsfishy]

I have a Products form that has a subformwhich list manufactures etc. In the subform theres a combobox where users can change the manufacture The list is has its control source as ManufacturerID. I want to be able to select a manufacturer the subform to bring up the matching id in the manufacturer form so that details can be changed.

I tried but it didnt work.
DoCmd.Openform "frmManfacturer", , , "[ManufacturerID]=" & Me.ManufactorID.Column(0)

 

[a.sinatra]

This should work...

Dim x As String

DoCmd.Openform "frmManfacturer", acNormal

Me.ManufacturerID = x
x = Forms!frmManfacturer!ManufacturerID

________
Honda fr-v specifications