I have a List box on a sub-form which will find records on the sub form based on the value selected in the list box but want to limit the records available in the List box to the Child field on the sub form that is matched to the Master field on the main form.
Can I adapt the code on the form - "
Set rs = Me.Recordset.Clone
rs.FindFirst "[WH_BlocksAssetId] = " & Str(Nz(Me![List0], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
" somehow to accomplish this.
The Child/ Master field is called UPRN.
Can I adapt the code on the form - "
Set rs = Me.Recordset.Clone
rs.FindFirst "[WH_BlocksAssetId] = " & Str(Nz(Me![List0], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
" somehow to accomplish this.
The Child/ Master field is called UPRN.
