Query pull variable from field on form

[MrsTFB]

I have an Access (2000) database that has a query ran from a form. I want the value that the query asks for (Part Number) to be whatever value is in PartNumber field on the form. I don't want the user to have to enter the part number for the query to run.

I know it's possible, just don't know the code to make it work.

Thanks for help,
MrsTFB in Tennessee

 

[traingamer]

Just have your query reference

[forms]![YourFormName]![YourControlName]

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill