Setting String Variables to Nothing

[tbaguio]

I've declared variables in my code to equate a value at the beginning of a loop and wanted to "re-set" the variable to nothing at the end.

Part of it looks something like:

Dim dbs As Database
Dim rst As Recordset
Dim rstFilter As Recordset
Dim GetDate As String 

GetDate = Forms!frmMain!ActiveXCalendar.Value

Set dbs = Nothing
Set rst = Nothing
Set rstFilter = Nothing
GetDate.Value = ""

This is only excerpts of my code. Anyhow, I get an "Invalid Qualifier" message when I reset the GetDate value in this way. What's the proper way to write this line?

Any insights? [sig][/sig]

 

[WP]

By referring to GetDate as GetDate.Value you are trying to reference the Vaule property of GetDate. However as GetDate is a simple string variable it does not have a valu property.

To reset to an empty string it's just GetDAte=""

WP [sig]<p>Bill Paton<br><a href=mailto:william.paton@ubsw.com>william.paton@ubsw.com</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

[/sig]

 

[tbaguio]

That worked. Thank you! [sig][/sig]