DateAdd or DLookup Problem

[RuralGuy]

Foolish me, not a big Dlookup guy as I've mentioned. OK, let's try:

Me.txt14 = DLookup("Birthdate", "tbl_clientinfo", "[ClientID] = '" & Args(0) & "'")

 

[Gilrucht]

I got it!!!!!!!!!!!! I'm not sure why but you have to use the actual field name and not the arguement reference.
-----------
Me.Txt14 = DLookup("Birthdate", "tbl_clientinfo", "(ClientID = " & Me.AAClientID & ")")
-------------
Now If I can only figure out why the combobox holds the case statement that opens the form I'll be all set.

Thank you very much. Thank you, too. Rich. You had the right idea. I just had to change the clientid to the current form. You were using the clientid from the previoys form which was already closed.