Tried to set Default Value

[Martyh]

I Tried to set Default Value with a global variable ... a combo box -cboFiscalYear with the current fiscal year ... [modGlobalVar].[intFiscalYear]

ie the Defaultvalue property of the
combobox = [modGlobalVar].[intFiscalYear]

However, there was no joy.

What am I doing wrong?

 

[RuralGuy]

Have you tried combobox = intFiscalYear?

 

[pbaldy]

Plus, if you mean in design view of a form, you can't refer directly to a VBA variable. You'd have to create a little function that returned the value of the variable, and call that.

 

[Martyh]

Thanks guys for answers!!

However:

RG: I tried setting combobox's Defaultvalue property to "= intFiscalYear" --- does not work

PBaldy:
I also tried creating a little function that returned the value of the variable, and calling it. But there was still no joy!

There must be something that I am doing wrong --- this is Access 2000! is that the problem?

 

[pbaldy]

I have A2k and it definitely works. It would look like:

=FunctionName()

You're saying it's not working, but you're not saying what that means. Error, no value, etc.

 

[missinglinq]

I have to ask; where are you setting the value of your global variable?

This link has a function for converting dates to fiscal years. MAybe it'll help.

http://forums.aspfree.com/microsoft-access-help-18/fiscal-year-format-21415.html