How do i get the value from a comboxbox and link it to print.

[MelonFuel]

Hi


Im in a spot of bother.


What i need to be able to do is write vba to find the value inside the comboxbox and then either:-


1. Run a macro with the same value that is in the combobox


Or




2. Run a set of reports and print them off but are linked to the combobox value.


The combobox name is ODTyper
The combobox control source is ODType which is a field in TblType
The combobox row source is SELECT [TblType].Model FROM TblType;
The value inside the combobox are in the format of TE4700
The name of the macros are in the format of TE4700
The Main form is called FrmOrderDatabase.


Plus somehow i need to get the value of the combobox and link it to print off the correct reports.


Thanks MelonFuel

[June7]

1. The combobox value is the macro name or a parameter used by macro? Why not just use VBA to do what the macro does?
DoCmd.RunMacro ......

2. Try:
DoCmd.OpenReport "reportName", , , "ODType='" & Me.ODTyper & "'"

[MelonFuel]

Hi June7 This is the code i have now. Code: If NZ(Me.ODTyper,"") <>"" then DoCmd.RunMacro Me.ODTyper But it gives me this parameter on every report if there a way to remove it. Thanks MelonFuel

[June7]

The macro opens reports?

One of the reports or the query it has for a RecordSource or maybe in the macro, something called TblQueue.ODWonNo is referenced and Access can't find this entity. You will have to track it down and fix the reference.