Hi
I'm having what i would guess is a really trivial problem. i have searched the forum but nothing can solve my problem: here is my sql code that goes into a edit box control:
SELECT targetFromVenue Activity.target
FROM venues INNER JOIN (Activities INNER JOIN targetFromVenue Activity ON Activities.Acti vitiesID=target FromVenueActivi ty.activityID) ON venues.venue=ta rgetFromVenueAc tivity.venueID
WHERE (((targetFromVe nueActivity.ven ueID)=Forms![shift viewer]!venueID) And ((targetFromVen ueActivity.acti vityID)=Forms![shift viewer]!activityID));
the query view of this works fine, but in the form i get #name? - what 2 do?
I'm having what i would guess is a really trivial problem. i have searched the forum but nothing can solve my problem: here is my sql code that goes into a edit box control:
SELECT targetFromVenue Activity.target
FROM venues INNER JOIN (Activities INNER JOIN targetFromVenue Activity ON Activities.Acti vitiesID=target FromVenueActivi ty.activityID) ON venues.venue=ta rgetFromVenueAc tivity.venueID
WHERE (((targetFromVe nueActivity.ven ueID)=Forms![shift viewer]!venueID) And ((targetFromVen ueActivity.acti vityID)=Forms![shift viewer]!activityID));
the query view of this works fine, but in the form i get #name? - what 2 do?
Comment