Lookup For The Value In A Field

[RockOnRay]

Good Morning ,

I am working on a database where i have to show the user last modification date of the files they are getting the data from. I have already completed that process. Used GetDatetime to find the files last modification date and time. And now i am moving on to the next step and Here is the scenario.

User will click the IMPORT button and first, it will check the last modified date in the form of those files(which is an unbound textbox) and compare that date with the Date Column that exist in the tbl_Import. If the Date matches it will show them a message Saying "Data cannot be imported since it already exist. If it doesnt match it will run the macro i have created to run the data import process. how can i code this? Please help. Thanks in advance.

[June7]

I use only VBA:

If Not IsNull(DLookup("[Date Column]", "tbl_Import", "[Date Column]=#" & Me.textboxname & "#")) Then
MsgBox "Data cannot be imported since it already exists"
Else
'run import
End If