Use the AfterUpdate Event of the ComboBox and some canny object naming:
Dim strReportName As String
strReportName = Me.cmbServiceType
strReportName = "frm" & strReportName
DoCmd.OpenForm strReportName
Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
"Burghew" <bu*****@mailinator.com> wrote in message
news:cp*********@news-dxb.emirates.net.ae...
Hi all,
I have a form which is used to enter workorder details. Now for the
service
types I have a one to one relationship with the different services
available. Each Work order detail may have many services (of differnt
types
with differnt field values). I need the WorkOrderDetails form to display a
combo from which the user can select the service type and based on this
selection show the appropriate form (eg: frmPlumbing when service type is
plumbing, frmengineering when service=engineering, frmcooking when
service=cooking). Please help.
TIA
--
Regards,
B