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

M

MelonFuel

Joined
Jun 15, 2012
Messages
5
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i get vba to get a value from a combobox and make it run a macro 0
fill a field from a combobox 7
ComboBox 1
ComboxBox with Dynamically Defined Source, and LinkedCell error 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Need combo box to refresh when moving to new record 2017 1
trim in rowsource with Right(), forcing a String return value with $,Access 2007 4
Using a function to get values into a combobox 9

Top