Update subform from a textbox

[puakenikeni]

I want to use a textbox to be the criteria for a subform. How do I got about refreshing the subform as someone types into the textbox? I'm just placing a basic "requery" subform command, but I've placed it in the AfterUpdate, BeforeUpdate, OnDirty, and Change events, and I have to click outside of the textbox to get the subform to requery.

Is there a way to update the subform while something is being typed into the textbox, or after someone finishes typing?

 

[boblarson]

It would go in the On Change event but you need to use the correct syntax for the criteria. What is your criteria for the query underlying the subform?

 

[puakenikeni]

My criteria is listed in my query. It's:

SELECT Master.ProgramName, Master.[Item Description], Master.ItemClass, Master.PropertyClass, Master.AcquiredFrom, Master.Gtag, Master.ItemClass, Master.ManufacturerVendor, Master.ModelNumber, Master.SerialNumber, Master.PartNumber, Master.Quantity, Master.UnitCost, Master.CurrentLocation, Master.Disposition, Master.DispositionCloseout, Master.DispositionLocation, Master.DispositionCloseoutDate, Master.DispositionComment
FROM Master
WHERE (((Master.[Item Description]) Like Forms!frmInventory!cboItemDescription_tab4)) Or (((Master.SerialNumber) Like Forms!frmInventory!txtNumber_tab4)) Or (((Master.PartNumber) Like Forms!frmInventory!txtNumber_tab4));

Did I put the criteria in the correct place? The subform's source is this query.