Form Subform refreshing

[j1nk5]

Hello,

I have a form that has 2 text boxes that I want to use as criteria for a subform.

I want the subform to refresh everytime a key is pressed. The problem seems to be that the control does not hold the value until I have finished typing. Is there a way around this?

 

[WayneRyan]

J,

You can use the control's OnChange event to do a Me.YourSubForm.Requery

Since you'll only have part of the strings, you'll have to use the LIKE.

Wayne

 

[j1nk5]

The on chance does run the code the problem is that the text box that I am typing in does not take the value until I loose focus. So the criteria at point of running is always nill.

 

[WayneRyan]

J,

Don't have an example now, but I think you have to use Me.Control.Text
to get the value.

Wayne