 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / June 2005Still no luck: pulling criteria from a form.
Sorry for the re-post but the proir thread ended and I'm still dead in the water. So again, if anybody can help, I'd be appreciative. I am trying to pull a form field as criter for the underlying query. I enter [Forms]![frm_DealMaster]![Staleflag] I get this using the builder and browsing to the form so I know spelling and existence are not issues. Everytime, I get "Enter Paramete Value". Why can it not locate this field? >Sorry for the re-post but the proir thread ended and I'm still dead in the >water. [quoted text clipped - 6 lines] > >Everytime, I get "Enter Paramete Value". Why can it not locate this field? Two questions: - Is the Form open at the time you run the query? - Could you post the actual SQL of the query? Specify the datatypes of the fields. John W. Vinson[MVP] John, Your questions prompted me to try running the query with the form open. I didn't get the error this time but, it failed to pull the form field's value. Would you still like to see th SQL? Or is there something simple I'm doing wrong? The form field I'm trying to pull is a check box. Does a check return "1"'s and "0"'s? > >Sorry for the re-post but the proir thread ended and I'm still dead in the > >water. [quoted text clipped - 14 lines] > > John W. Vinson[MVP] >John, > >Your questions prompted me to try running the query with the form open. I >didn't get the error this time but, it failed to pull the form field's value. > Would you still like to see th SQL? Or is there something simple I'm doing >wrong? The form must be open or it will indeed prompt you. I obviously cannot tell what you might be doing wrong, since I cannot tell what you're doing! >The form field I'm trying to pull is a check box. Does a check return "1"'s >and "0"'s? Actually, -1 is TRUE/Yes/checked and 0 is FALSE/No/unchecked. John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.