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

passing values from a form to a query

P: 35
Hi,

Can someone have a look at the below query point me in the right direction please? With the form flood_search open I get a popup box asking for [forms]![flood_search]![osapr] - any ideas?? It's in 2000 and the columns in the SELECT are just to shrink the amount of code

Expand|Select|Wrap|Line Numbers
  1. SELECT AddressPoint.columns, address_details.columns
  2. FROM addresspoint left JOIN Address_details ON address_details.OSAPR = AddressPoint.OSAPR
  3. WHERE AddressPoint.OSAPR=[forms]![flood_search]![OSAPR];
  4.  
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,

Can someone have a look at the below query point me in the right direction please? With the form flood_search open I get a popup box asking for [forms]![flood_search]![osapr] - any ideas?? It's in 2000 and the columns in the SELECT are just to shrink the amount of code

Expand|Select|Wrap|Line Numbers
  1. SELECT AddressPoint.columns, address_details.columns
  2. FROM addresspoint left JOIN Address_details ON address_details.OSAPR = AddressPoint.OSAPR
  3. WHERE AddressPoint.OSAPR=[forms]![flood_search]![OSAPR];
  4.  
Forms has a capital F

[Forms]![flood_search]![OSAPR]
Sep 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.