Problem With Combo Boxes

[Guest]

Hi, have converted a '97 app to 2003. On the main menu I have 2 combo boxes
where the user can set the accounting period and year (selected from tables
containing 1-12 and January to December).

This is populated by default (Default Value) to the current period and year,
but as they may want to do some prior period work the idea is that they can
set a period/year to be used in their session. These are then stored as
controls to be passed to subsequent forms.

This worked fine in '97 but now they are unable to change the default.

Any ideas ?

 

[Douglas J Steele]

How are you setting the Default Value in Access 97? As far as I'm aware,
there's been no change to the Default Value functionality in any of the
subsequent versions of Access.

 

[Guest]

Hi Doug,

The value is set by calling a function from the Default Value property,
function code is:

Function DEFINEPERIOD()
'Set the period number in main menu & crosstab queries

Curper = Month(Now)

If Curper <= 4 Then
Curper = Curper + 8
Else
Curper = Curper - 4
End If

DEFINEPERIOD = Curper

End Function

 

[Arvin Meyer]

Try using the Fiscal year function from my website. It can be used in
queries, to set a global variable, or in individual forms or reports.

http://www.datastrat.com/Code/FiscalYear.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access