John,
HomeInfoID is in the Listings table.
Connie
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Connie-
>
> Is HomeInfoID in "Listings"?? DLookup builds a query:
>
> SELECT HomeInfoID
> FROM Listings
> WHERE [ListID] = <the value of the control on your form>
>
> If HomeInfoID isn't in Listings, then that's the problem.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Thursday, October 20, 2011 8:06 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [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
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar