Need to Filter Query with textbox

[jmshipe]

Okay, so I know this sounds easy, but for some reason I'm having alot of trouble working this out. I've looked for the answer on other posts, but nothing has worked.

I have a form with a text box ("txtbox1"). When this number is updated with the update function I want it to filter a query WHERE [Field] = "txtbox1" value.

The query is displayed in a subform. It draws its information from one table.

My code is a mess right now so I won't post it. I can answer any questions though.

Thank You

[jzwp11]

When this number is updated with the update function

What is this "update function"?

Is the main form bound to a table or query?

How are you triggering the subform to be requeried when the value is "updated" in the textbox?

Generally you have to physically enter a value in the text box before any of the events are triggered. Just changing it via code will not trigger any textbox events.

[dreday]

try: WHERE [Field] = " & txtbox1 or WHERE [Field] = " & me.txtbox1