How to open subform to specific records based off of input from combo boxes

[mayestom]

I need to open up a form to specific records in its subform based on user input from combo boxes (Customer and/or PKGEngineer). The two combo boxes are on a switchboard. How can this be done?
Thank you.
Using:
Win 7


Access 2010

[ranman256]

You dont need a sub form. If you have a form (tab view) continuous records.
Put the filter controls on the header and a button APPLY FILTER
the button AFTERUPDATE event is:

dim vFilt

if not isnull(cboST) then vFilt = vFilt & "[state]='" & cboST & "' and"
if not isnull(txtName) then vFilt = vFilt & "[Name]='" & txtName & "' and"
if not isnull(txtProd) then vFilt = vFilt & "[Product]='" & txtProd & "' and"
 

  'remove the last AND
vFilt = Left(vFilt, InStrRev(vFilt, "AND") - 1)

  'Apply filter
me.filter = vFilt 
me.filteron = true

[Bob Fitz]

Cross-posting: http://www.access-programmers.co.uk/...d.php?t=267697


Please read: http://www.excelguru.ca/content.php?...-cross-posters

[mayestom]

Sorry for the cross post. I did not know. Original post is here.
So I'm not sure what to do? Do I post a reply on this post or reply on the original post?

[Bob Fitz]

Sorry for the cross post. I did not know. Original post is here.So I'm not sure what to do? Do I post a reply on this post or reply on the original post?

Hmmm I'm not sure either to be honest. Therein lays another problem when cross posting. I would suggest you reply in each thread as and you have something to post. At least as things stand now, those trying to help will be aware of the other thread. If you find a resolution to your problem I think it would be polite to let those in the other thread know.

[mayestom]

Okay. Sorry again for cross posting. I have posted a link on the original post to this post.
ranman256 can you please post to the original post? I don't think I explained this properly. I have a little better explanation with pictures on the original post. Thank you for replying.