I am using this Access code (as provided by the lookup wizard) to search a field on my form and on the click event of the lookup list, i will go to that record.
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[txtPurchaseOrderNo] = '" & Me![List109] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
I have a subform on the form and wondered is there a way to set the recordset (rs) to a field on the subform and not the form. However, I need the lookup field to exist on the form. Thank you
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[txtPurchaseOrderNo] = '" & Me![List109] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
I have a subform on the form and wondered is there a way to set the recordset (rs) to a field on the subform and not the form. However, I need the lookup field to exist on the form. Thank you