shieldsco
asked on
Access 2010 Drill Down to Another Form
I have a form (frm_Accounting_Transactio ns) with a field (Fund_Map) that has multiple values separated by commas (EC,EG,EM,EP,ER,ES,ET,TR)
I would like to drill down to another form (frm_fund_Groups) field Fund Type Code and display only the records based on the multiple values from the Fund_Map field on the frm_Accountinng_Transactio ns. Thanks
I would like to drill down to another form (frm_fund_Groups) field Fund Type Code and display only the records based on the multiple values from the Fund_Map field on the frm_Accountinng_Transactio
ASKER
I get compile error Method or Data Member no found on both..........txtFund_Map
ASKER
Please note - the number of pairs vary with the records... some records my have three pairs while other records my none (null) or 1 or 5 etc
ASKER
DB attached
ATM-V.1.1---Copy.accdb
ATM-V.1.1---Copy.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can also give this a try:
DoCmd.OpenForm "frm_fund_Groups", , , "InStr('" & Me.Fund_Map & "',[Fund Type Code])>0"
Ron
ASKER
Very Good-- Thanks
So did you the other solution not work?
docmd.openform "frm_fund_Groups",,, "[Fund Type Code]='" & me.txtFund_Map & "'"
or
docmd.openform "frm_fund_Groups",,, "[Fund Type Code]=" & chr(34) & me.txtFund_Map & Chr(34)