create filter from a seperate form?

[garbett_d]

hey,

i have created a complete database and would like to create a filter? i want a single extra form that has an input section and a button, once the person inputs the criteria they want to search they click the button. This then searches through all the data in a specific table and brings up the single matching item.

hopefully somebody has more idea than me as im quite stuck, if some body does know could they try and explain it in terms that i could understand, im only just getting to grips with this access jargon lol!

Cheers in advance

 

[Fizzio]

There are a myriad of ways of solving this one you'll be pleased to hear, all of which have been discussed at some point here. Use the search facility here to search for 'search form' and see what results that throws up. If nothing fits the bill, post back.

Happy hunting.

 

[garbett_d]

i couldnt find alot none of it related to what i wanted?
all i want is a seperate form where i can input a part number and then it searches through the main table and brings up the report for that specified part number?

 

[Fizzio]

OK.

If all you want to do is filter a report, on the form with the part number search box, on the AfterUpdate of the textbox (or via a button) use the openreport method

Docmd.openreport "YourReport",acViewNormal,,"[PartNumber] = '" & Forms!PopupFormName!TextboxName & "'"

This will print the report but you can use acViewPreview to preview instead.
PartNumber is the name of your Partnumber field etc.

hth