Parameter by textbox on form not working

[nstratton]

I have an unbound form with various criteria selections available and I am trying to add a new one to the ones already there. I am wanting to add a text box to perform a partial field match on a table.

I have put the text box name in both the criteria field and the parameters menu and it works if the form I am using is not open. When I try to enter a value through the form the query returns all values. I am typing in numbers into the text box but the field I am searching is "text". Would that be the issue?

I am trying to compare the last 6 characters in the field with what is placed in the textbox.

The criteria field is set up as

Like "*" & [Forms]![frmSortingMenu]![Text59]

 

[nstratton]

I am not entirely sure what I did to fix this but it seems to have resolved itself.
Would moving to another box on the form fix this?
I think that is what I did before I hit run but hoping to get expert opinion on maybe why it was not cooperating before.

 

[Brianwarnock]

The answer to the question is yes, the data is only available when you move off the control IE textbox or hit enter.

Brian