Originally Posted by
Amerlitong
...I made this query linked to a textbox...
Putting aside, for the moment, that fact that you're trying to match a Text value with a Date value, how did you manage to "link a textbox" to a Query? You cannot use a Query or SQL statement as the Control Source for a Textbox. For this kind of thing you'd have to use the DLookup function.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007