Thanks.



I have resolved this issue now.

I created a query of Propref and then concatenated hsno and address 1 with space. and then used my search code like previous to link the proprefs. So user now enter for example 32 smith street and if this address has a propref it finds it and brings it up in form.