Multi-criteria drop down link to subform

J

James C.

Hi all,

I have bound subform "frm_Summary" that links to my master data table
"tbl_Contractor." At the top of this form I have two combo boxes "cmb1",
"cmb2"

- Cmb1: queries tbl_Contractor and brings back the Invoice number, I am
using the afterupdate to then populate Cmb2 and bring back the project name
based on the invoice number selected.

I then have my subform update to the first record that matches the invoice
number. Her is my code

Code:
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Invoice#] = '" & Me![Cmb1] & "'"
Me.Bookmark = rs.Bookmark
Me![Cmb2] = Me.Project

My problem is sometimes there are two projects per contract number. I want
to be able to select dropdown 1 and make a choice and if dropdown 2 has more
than 1 possiblity select that dropdown and pick my choice and have the
subform display based on both options.

Can this be done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter List Box based on multiple Combo Boxes 7
Update Textbox based on Selection from Multiple Comboboxes 2
Filtering Combo #2 from a value in Combo #1 6
How to make repeating drop-down lists? 2
Links 1
select record based on record selected in the child form 4
Refer to control on 3 pages tab control in subform within form 4
how to populate a listboc with the result of two combobox 14

Top