Microsoft Access 2000 Question

[Megadeth]

On my form I have 2 fields that I am concerned with in regards to this question.
The first field is the Address field.
The Second Field is an unbound field.

In the second field I want data to fill in based on What the address is. The second field is just going to have 2 values... Y or N.

So I have 2 tables both with address fields. I want the unbound text box to fill in Y if the Address in the first table exists in the second table and a N if it doesnt.

I really thought this was going to be simple but I'm running into several issues.

I have been trying to use Dlookup but thats not going well at all...
Example:
If Me.address.Value = DLookup("address", "SPECIAL", "[address]=" & me.address.value) Then
Me.Test1 = "Y"
Else
Me.Test1 = "N"

That's just one of a dozen variations of things I've tried....
Am I just going about this whole thing the wrong way?

 

[Megadeth]

Problem Solved.... Apparently, Access didnt like that both tables had a field named address... I changed the other tables Address field to Address2 and everything works fine now.