#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    3
    Rep Power
    0

    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.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2012
    Posts
    3
    Rep Power
    0

    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.

IMN logo majestic logo threadwatch logo seochat tools logo