Referencing a Public Variable in multiple modules?

[davidb88]

Hi - Is it possible to reference an established public variable in another module other than the one it was created in? In my database I have a main form page where the user selects a date from the calendar. The way that I have this set up is:

Public modeldate As Date
'Model Date Select
Sub textModelDate_AfterUpdate()
Dim subseqDate As Date


'set modelDate equal to TextBox
modeldate = Me.textModelDate.Value


'check for month end date selected, if not then set modelDate to 0
subseqDate = DateAdd("d", 1, modeldate)
If Month(subseqDate) = Month(modeldate) Then
    MsgBox "Please choose a month-end date for the Model Run Date."
    modeldate = 0
End If


End Sub

I would like to then be able to reference this variable "modeldate" in other modules but as it stands right now anytime I reference it, nothing appears which makes me think that I am doing something wrong with establishing the variable. Is there an easier way to do this or am I just missing something in the code I have right now?

Thanks!

 

[xenou]

^^ Yep, either I would hide the form rather than actually close it. Or store the variable, either in a public variable in a standard module a la revver's previous post, or by saving the datum in a table where I can retrieve it as needed.

It depends on the situation. What is this date and what are you actually doing with it? How is the form involved in what the user is doing?

Note that with Access 2007 we have the option of using TempVars as a "global" variable without having to use VBA for this.