Dlookup on a bound form

[Raddle]

Hi



I have a form with fields displaying data from the main table.
I would like to add a new field with a Dlookup, to look in another table for contact info.

=DLookUp("[Contact_1]","Tbl_Teams,"[MaintTeam] = '& me.Team_Name &'")

Is this possible?

I guess one answer would be to run a query for the form and base the whole thing on that, but I don't really want to do that for other reasons - the contact information is actually in two different tables. I jknow ..

Even as I type I sense this is not possible with this schema.

Any hints ?

[Micron]

Why don't you just try it and find out for yourself in less than five minutes? I don't see why it would not work as long as your syntax is correct (which it is not). Maybe

=DLookUp("[Contact_1]","Tbl_Teams","[MaintTeam] = '" & me.Team_Name & "'")

[Raddle]

Hi - thanks for coming back to me.

Yep fair comment and I did try a query, and it worked perfectly.

However using your code I get a Name? error, which I think might be due to the fact that I have the fields set out on tab pages, which might be tanking the me. part of the snippet.

But I will keep plugging away.

Thanks again

[Micron]

Then stick with what works I guess. We can only base answers on the details anyone presents. If referenced controls lie on things like subforms, nav forms or tab pages and no one says so, success is not likely. This occurs all the time.

Then again, in this case I think the problem is the Me reference in the controlsource. You would just use the field name as long as it's part of the form recordsource, which I guess it is otherwise you would not have thought to use Me. So removing me should work.