access controls on the spreasheet

's Computer Specifications

I have a combo box on the spreadsheet to let user select the option.

I wanted to print a field base on the combo box.

Are there any way to reference the combo box?

I tried to use "occurrence " & cmbYear, but I got error.

Your help is great appreciated,

's Computer Specifications

hi
tad sketchy on the details but try this.....
assuming the name of your combo box is cmbYear....

cmbYear.value

Regards
FSt1

"inungh" wrote:

> I have a combo box on the spreadsheet to let user select the option.
>
> I wanted to print a field base on the combo box.
>
> Are there any way to reference the combo box?
>
> I tried to use "occurrence " & cmbYear, but I got error.
>
> Your help is great appreciated,
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restricting Access to Controls Based on Information from other Controls	Jason Lopez	Microsoft Access Forms	0	12th Jul 2007 08:24 PM
In a spreasheet, how do you move a column around?	Spin	Microsoft Excel Discussion	4	28th Jun 2006 10:53 PM
Form with Spreasheet	=?Utf-8?B?aW13YWxydXMzOA==?=	Microsoft Outlook Discussion	2	2nd Jul 2005 05:17 PM
regarding to Spreasheet Toolbar	Microsoft News	Microsoft Excel Worksheet Functions	0	25th Nov 2004 02:02 PM
Not to print one row within a spreasheet	=?Utf-8?B?SEJhdW1hbm4=?=	Microsoft Excel Misc	3	18th Oct 2004 06:53 PM