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

Query By Form (QBF) Questions

P: 17
This is my first QBF and i am following along with the Microsoft Example but it does not answer this question.

I hve a 2checkbox,2label, & 2unbound cbo. I want to pass the value from the unbounds to the query for the 2 fields. How is this done?
I have tried editing the SQL statement with the criteria pointing to the unbound box and it is not working.


CBO1 SQL
Expand|Select|Wrap|Line Numbers
  1. SELECT tblRISK.PKNumber_WorkFlow, tblRISK.CTSID, tblRISK.Taxcode, tblRISK.Period, tblRISK.CTSNAME, tblRISK.ID, tblRISK.Cause FROM tblRISK ORDER BY tblRISK.CTSID; 
  2.  
Sep 11 '08 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,470
I'm not clear what you hope to do with your SQL (this is often important).

There appears to be no references in your SQL to any form controls (which you imply in your explanation).

I'm not sure where to lead you from here.
Sep 11 '08 #2

Post your reply

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