I know this question has an incredibly simple answer but I'm claiming newbie so here goes...

We have an application that produces a report based on a part number which is hard-coded in a program file of the project. At the beginning of the code is a simple statement that says myFilter = "partnumber" and then goes from there. If I leave a few characters off the end of the part number it inclusively selects and prints reports for all parts that fall it can create a match.

Since all user requests are brought to me to run this report I want to create a simple one-textbox form that users can enter this information into, run their own reports (and quit bugging me). I'll call the textbox txtPart.

On a form, I've included a textbox to accept the input and a command button to run the program file.

In the "click" event of the button I've placed the following...

myFilter = thisform.txtPart.Value

go (program name)

However the value typed in is never connected with the variable. What am I missing here?

FYI I am using version 5. It looks like there is in input box feature on newer versions but I don't think I have it yet.

Thanks!

Alan