Search results

spikepl, Will make sure to not throw out numbers, first post and all that here. As an update, I've tried a few alternatives, still with no success. Now, on the main (unbounded) form I've got: Private Sub txt_CheckNo_AfterUpdate() Dim SrchVar As String SrchVar = Me.txt_CheckNo...

boerbende, Thank you for the reply. I follow you, but what I need is for the subform to be in datasheet view with all the records present, but have the SrchVar found record highlighted. I see where you're going, I just don't want to filter down on the WHERE clause.

I have an unbound form: frm_ReceiptSearch with some fields that, when something is input, will search a datasheet viewed form on a subform on the main form (subform name is sf_frm_Receipts). Currently, on the txt_CheckNo field's after update event, I have the following code: Private Sub...