How to dereference a variable.

[evander]

Hi guys!



I want to know what's the proper way of dereferencing variables, as I'm a programming novice.

I have...

Private Function Something(ByVal SomethingElse AS String) AS Integer
   Dim db AS DAO.Database
   Dim rs AS DAO.Recordset

   Set db = CurrentDB
   Set rs = db.OpenRecordset("SELECT TOP 1...")

   Something = rs.Fields("...").Value

   ???I dont know what to do next... 
End Function

Please help. Thanks a lot.

Joe

[RuralGuy]

Set db = Nothing
Set rs = Nothing

[evander]

Thanks! I'll mark this solved.

[evander]

All the custom functions in my db are not de-referenced. Will they cause any serious problems? I'm doing my homework... But it's painful to learn by experience.

[RuralGuy]

Technically, Access should DeReference the variables when the function goes out of scope but most developers do not leave it up to Access. It has not always worked in the past.

[evander]

Okay, I will insert the set nothing codes tonight. Thanks mod.

[RuralGuy]

Glad we could help here.