|
Hi
I have an unbound combo box on a bound form (bound to a Sites table)
that i want to fill with a list of data from an attachments table that
contains the paths of the attachments for each site. Each site has a
unique Site Ref which is also stored in the attachments table.
In the rowsource of the combobox i have:
SELECT [Attachments].[SiteID], [Attachments].[AttachPath] FROM SITES
INNER JOIN Attachments ON [SITES].[ID]=[Attachments].[SiteID] WHERE
[Attachments].[SiteID]=me!txtSite_ref
However, this doesnt fill the combo correctly and when i click on the
combo i get the "Enter parameter value.... me!txtSite_ref" box.
Any ideas where im going wrong?
Thanks
Paul
| 
