Open a form and filter options

[Precips1]

Hi,

Struggling at the minute with this problem.

I'm trying to open a form and filter the table contects depending on which button is pressed. eg. Once the main form opens, I only want to see records that contain the products for the given button that’s been pressed. eg. Button 1 pressed = "AC39" Form 2 opens and only shows all the records with the product name "AC39"

Form 1 is called [Switch Board]
Form 2 is called [sfrmTankerInfo]
Textbox I want to filter by is called "Products" and would only hold 4 products "AC39", DH338, R550, AC43

Just can't get it to filter?

Any help is much appreciated,

Mike

 

[pbaldy]

You can use this technique, but hard-code the options (or have one button and a combo or something for the user to select, which would make it more dynamic in the long run).

http://www.baldyweb.com/wherecondition.htm

 

[Precips1]

Thanks for the link buddy - All working a treat now.

Mike

 

[pbaldy]

Excellent Mike, glad it helped you.