Pre populating a field

[Fairportjay]

I am trying to have my field pre populate the users name. I am using a function to look up the current users sign on info.. that works great I then am trying to use that info to prepopulate a field with their full name. I have a table with all the info in it. I tried to use the d lookup but it is not returning a value



the code is
=DLookUp("[Name]","Employee listing","User name"= CU())

Name is the field I want to return from the employee listing table when user name = CU ....... CU is the name of the function that returns the current user name using Environ("USERNAME")

it has to be something silly I am doing. any help would be welcome

[EZ Access Gideon]

You could try:

=DLookUp("[Name]","Employee listing","[User name]=" & CU())

[June7]

Should not use reserved words as names for anything. Name is a reserved word. Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.

Assume [User Name] is a text field which means parameter needs apostrophe delimiters.

=DLookUp("[Name]", "Employee listing", "[User name]='" & CU() & "'")

[Micron]

If the suggestion works, it points out why you should never have spaces or special characters in names (save for perhaps underscore). I'd also mention that you should not use reserved words for your names (e.g. Name). See
http://access.mvps.org/access/general/gen0012.htm
http://allenbrowne.com/AppIssueBadWord.html

If the function can return null, your code will experience another problem. DLookup doesn't handle Null very well.

[Fairportjay]

so I fixed the naming conventions and works great.. thanks everyone