Use 2 Combo Boxes to look up Record and Display it in a form

[rhuseman]

Below I have a link to a video to help explain my question and problem. I am wanting to search for existing records in a table by using 2 combo boxes. One combo box will choose an existing variable (the part number) and the other combo box with control another existing variable (operation number). copy the following link to browser


http://www.youtube.com/watch?v=r6hDy5EQ-4w

I need some input and help to figure this out.

[DepricatedZero]

Can't watch the video right now but

You can target your combos from a specific query to set your criteria like so

Under "Where" for Criteria enter something similar to Forms!frmContainingControls.ctrlThatHasVariable

Then you can design a custom query that checks those controls for its criteria

[dccjr]

I created multi-variable searches similar to what you are talking about as follows. Since I am still relatively new at Access VBA, I am not sure how eloquent or efficient it is, but it works.

strSQL = "SELECT * FROM [tbl_Name] WHERE PartNo= '" & Me.cbxPatNo & "' AND OpNo= '" & Me.cbxOpNo & "'"

I used combo boxes to help eliminate user typo errors with textboxes when searching. What type of control are you using to display the result(s)? Hope this helps.