Search results for query: *

I've seen a lot of forums dealing with similar subjects but I haven't seen one that answers this question. I have an .mde front end with more than one password protected backend. I want to dynamically call a SQL query on any database I select on a form on the front end. Example: strSQL =...

just figured it out . . . I made an error in a select case statement above this code so the dlookup function wasn't even running. What a goofball!! Thanks PHV, your post helped me to rethink the obvious.

Is it possible to get a VbCrLf or something with the DLookup result - something that might prevent it from assigning a string value?

yes. the response I get is what I expect. That's what makes this so frustrating - it seems easy enough.

Hi all - this is my first post, but I have read many, many threads previously so thanks in advance. I'm trying to set a variable called moDate to the value found in a table using the dlookup method. I have declared moDate as a string and assigned the value using: moDate = DLookup("[MP]"...