Form Filtering?

[NewfieSarah]

Hey all I am having a problem with my form filter. I was wondering if you can just direct a filter from form 1 to form 3 without referencing form 2. I am thinking not cause I am having a problem getting the filter to work. Here is the code I have in my load form.

framfiltval = "CONSTR_LOCATION = " + "'" + Form_PID.ADDRESS3.Value + "'"
Form.Filter = framfiltval
Form.FilterOn = True

Thank for the help in advance

 

[allan57]

Try this

Replace the + signs with an & ie

framfiltval = "CONSTR_LOCATION = '" & Form_PID.ADDRESS3.Value & "'"

 

[NewfieSarah]

nope that didnt work. Before the error was that I cant find the CONSTR_LOCATION and now that i changed it to an "&" the error is cant assing value to framfiltval