Simple Search AfterUpdate of the textbox

[dada123]

help me please... In my form, i have a textbox and a hidden subform/subreport. on after update of the textbox, the subform/subreport will then became visible then it will show a data from the table that has the exact value I inputted in my textbox.. here's the file for you to understand it very well.. Please help..

View attachment db.zip

 

[JamesMcS]

Hi! I think all you need to do is put something like this in the afterupdate of your text box, after empsub.visible=true:

    empsub.Form.Filter = "barcode=" & Forms!dtr.TxtCode
    empsub.Form.FilterOn = True

I think you'll also want to change the barcode data type to number in the table's design.