D
dd
I've got a report based on a query. The query asks the user for a SITE
location. It would be useful if I could create a form which lists the sites
in a combo box so that the user can select a site rather than typing it in.
Is there an easy way to do this?
SELECT SurveyData.[Date of Survey], SurveyData.Site, SurveyData.Element,
SurveyData.Condition, SurveyData.PriorityRef, SurveyData.[Revenue Cost],
SurveyData.[Revenue Comments], SurveyData.[Remaining Life],
SurveyData.[Capital Cost], SurveyData.[Capital Comments]
FROM SurveyData
WHERE (((SurveyData.Site) Like [Enter Site] & "*"))
ORDER BY SurveyData.[Date of Survey], SurveyData.Site, SurveyData.Element;
Regards
Dylan Dawson
location. It would be useful if I could create a form which lists the sites
in a combo box so that the user can select a site rather than typing it in.
Is there an easy way to do this?
SELECT SurveyData.[Date of Survey], SurveyData.Site, SurveyData.Element,
SurveyData.Condition, SurveyData.PriorityRef, SurveyData.[Revenue Cost],
SurveyData.[Revenue Comments], SurveyData.[Remaining Life],
SurveyData.[Capital Cost], SurveyData.[Capital Comments]
FROM SurveyData
WHERE (((SurveyData.Site) Like [Enter Site] & "*"))
ORDER BY SurveyData.[Date of Survey], SurveyData.Site, SurveyData.Element;
Regards
Dylan Dawson