August 15th, 2012, 04:24 PM
Macro wherecondition via cmb box w/ 4 columes
Over view: I have a form that opens via Mainform_sub.ID=More_Data.ID now I need the More_Data for to open Mainform via SSN. Both forms have the SSN field, on the More_Data the field is a cmb box w/ 4 columes (ID,SSN,Last Name, First Name). Bound colume 1.
Problem: I need my Macro (under OnClick) to openform based on cmb SSN.
Code: Mainform, Form, , "[SSN] = '" & [Forms]![More Data]![SSN] & "'", , Normal
What am I missing?
*This may be a repeat. I thought I posted but didn't see it.
August 20th, 2012, 09:43 AM
Issue- codes not running in 2007
I think the issue is that codes don't run at all in my 2007 MS Access. I will post a new thread but seeing as no one replied to this one I am not sure it will do any good.... lets hope I can fig out why not even a simple DoCmd.Close acForm, "Form3" isn't working.