RE: DLookup

From: Pat hartman (Pathartman_at_discussions.microsoft.com)
Date: 07/30/04 

Date: Fri, 30 Jul 2004 12:09:02 -0700

Name is a poor choice as a column name because it is the name of a property. When you use the names of properties, methods, or functions as the name of one of your objects, you frequently run into problems with VB/VBA. Access is way to lax in enforcing any naming standards. 

-- 
Bridge Players know all the Tricks
"Shanin" wrote:
> I was trying to make a query that used a form and the Dlookup to sort the data but am only getting blank results.
> 
> I had a form made with a dropdown box where staff could choose the employee they wanted and then hit the control button next to it to run the query and it would pull up all their training.  I also had one so they could choose the department and it would list every employee that has trained in that department.
> 
> I'm only using "Name", and "Training" (Name from tblEmployees, Training from tblTraining) in this query and using this as the criteria under "Name"
> 
> DLookUp("[Name]","[tblEmployees]","[Name] = '" & [Forms]![Train]![NameList] & "'")
> 
> My results keep coming back blank, or it will say it cannot understand the expression.
>