I have a form which is used to search for a property. Lets call this frmSearch. When i select a property from the list, it open the relevant record on frmHistoryProperties which a subform that contain a list of tenants that have occupied that property.
I was using the below method all on frmHistoryProperties but I have decided to place the search function on its own form to make room. To display the selected property I used the following which worked fine :
Me.txtStreetNo = Me.lstProperties.Column(1)
Me.txtStreetName = Me.lstProperties.Column(2)
but now that I have place the search function on a frmSearch, how do I
get the selected property from the list on frmSearch to populate txtSteetNo and txtStreetName, which are both unbound, on frmProperties.
I was using the below method all on frmHistoryProperties but I have decided to place the search function on its own form to make room. To display the selected property I used the following which worked fine :
Me.txtStreetNo = Me.lstProperties.Column(1)
Me.txtStreetName = Me.lstProperties.Column(2)
but now that I have place the search function on a frmSearch, how do I
get the selected property from the list on frmSearch to populate txtSteetNo and txtStreetName, which are both unbound, on frmProperties.
Last edited:
