I have a database that contains info on what code to run in a particular instance. The code that I have looks to see what file is in a directory. Once it sees a file it trys to match it up against what is in the database. If it finds a file who's name exists in the database, it needs to call a proceedure who's name relates to the file name in the db.

Ive got two fields in the table.
FileName and Code

I assign strFileName to = rs!FileName and strCode to = rs!Code.

Then I want to do this:

If Dir(strFileName, vbNormal) = "" Then
GoTo CONT
Else:
Call strFileCode
End If

How should I dim strFileCode. I guess it shouldn't be a string as VB keeps telling me that it looks for a proceedure there. Any ideas?