2. ASPRunnerPro General questions
  3. [SOLVED]  Addpage Lookup Wizard Where Clause
This topic is locked
[SOLVED]

 Addpage Lookup Wizard Where Clause

 		3/15/2013 7:57:37 AM
ASPRunnerPro General questions
M
 marcove author

HI
I need in ADDPage Form, there are 4 fields (Field1,Field2,Field3,Field4), and field4 must depend on the value of the Field3. So I put a Where condiction (in Where expression - Lookup Wizard) using the values("field3"), but it doesn't work and give error: type error!
Here a copy of the condiction as i wrote:
" IDPe='" & (values("field3")) &"'"
Pls could you help me?

Thank you

M
Sergey Kornilov admin 3/16/2013

You cannot refer to other field values in WHERE clause. The feature you looking for is 'Linked dropdown boxes': http://xlinesoft.com/asprunnerpro/docs/lookup_wizard.htm
M
 		marcove author 3/18/2013

Ok Thank you

M