By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,110 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

Combobox rowsource

P: n/a
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

Oct 31 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Try the full reference as Forms!NameOfForm!txtSite_ref

Oct 31 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.