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?
|
|