Dlookup's Please help

[H]

i am struggleing with D lookups, they work on my other database but not on this one. i have a table holding individuals info. so i want to input their initials and there name to automatically populate

=DLookUp("[Name]","[Individuals Details]","[Initial]='" & [Forms]![Comp Subform1]![Initial] & "'")

Soi want ot look up the name in the table when initials are selected on form.

does that make sense

the Initials on the form have to be selected from a list

thanks

 

[MikeAngelastro]

Please elucidate. I'm not sure what you are trying to do.

 

[The L&L Company]

I would try it like this:

=DLookUp("[Individuals Details].[Name]","[Individuals Details]","[Individuals Details].[Initial]= [Forms]![Comp Subform1]![Initial]")

Is this initial entry field actually on a subform? How are you executing this code - on the after update event of a textbox?

I hope this helps a little,
~ Joe Maluso