How do you set the ServerFilter property to the value of a form field?
setting it to CLid = 107 obviously brings back a row with the CLid field equal to 107, but I need to set it to the value in the following form field:
Forms![contractdetail]![ContractLines]![CLId]
CLId=Forms![contractdetail]![ContractLines]![CLId] doesn't work, nor does
"[CLId] = '" & Forms![contractdetail]![ContractLines]![CLId] & "'"
Thanks.
setting it to CLid = 107 obviously brings back a row with the CLid field equal to 107, but I need to set it to the value in the following form field:
Forms![contractdetail]![ContractLines]![CLId]
CLId=Forms![contractdetail]![ContractLines]![CLId] doesn't work, nor does
"[CLId] = '" & Forms![contractdetail]![ContractLines]![CLId] & "'"
Thanks.