Search results

Slight modification: Installed this on the AfterUpdate event of the search box in the header of the subform: Private Sub txtNameFilter_AfterUpdate() If Me.Recordset.RecordCount = 1 Then Call ContractNumber_Click End If End Sub Works like a champ, thanks very much!

Simple enough, clicking on the contract number in the search subform filters the parent form like this: Private Sub ContractNumber_Click() Me.Parent.Form.Filter = "[ContractID] = " & [ContractID] Me.Parent.Form.FilterOn = True Me.Parent.Refresh End Sub I'd just like that to be automatic when...

Greetings All - I have a data form that includes a search subform for contracts (unique "ContractID"). The subform is continous. It uses an unbound text field that dynamically filters the returned records on key up. Whether before or after filtering - if a record is clicked in the subform, the...