Kamis, 20 Oktober 2011

[MS_AccessPros] Control Source using DLookup

 

Hi all!

In case it's relevant I am using Access 2007. I recently figured out that DLookup can be used as a Control Source. I had the following working, but when I just opened up the form it is not. Before the form opens there's a needs parameter message asking for HomeInfoID. And once the form opens the box has "?Name" in it. Here's what I have in the Control Source box:

=DLookUp("[HomeInfoID]","Listings","[ListID] = " & [ListID])

Thanks,
Connie

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar