 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / June 2007can some tell me what's wrong with this code?
I am trying to call the itemnamecb afterupdate event from another open form I have made that event public the contol name is itemnameCb. using access 2003 Forms!eventfrm!orderSF!itemnameCB.itemnameCB_AfterUpdate() this turns red and says it expected "=". tried removing () but that didn't help. thanks for any suggestions Did you try: CALL Forms!eventfrm!orderSF!itemnameCB.itemnameCB_AfterUpdate() ??? > I am trying to call the itemnamecb afterupdate event from another open > form [quoted text clipped - 6 lines] > didn't help. > thanks for any suggestions Thank you, Yes i did try that. When i do, the entire statement turns red, the first "!" is selected and a dialog opens saying Compile error: "expected: . or ( . " I tried replacing ! (s) with periods but that generates other errors. What are you trying to do excatly, that you need to call the afterUpdate routine in the other form? Why don't you create a PUBLIC sub and call it instead? > Thank you, > Yes i did try that. When i do, the entire statement turns red, the > first "!" is selected and a dialog opens saying > Compile error: > "expected: . or ( . " > I tried replacing ! (s) with periods but that generates other errors. Too much information for Access. Try Call form_orderSF.itemnameCB_AfterUpdate() Yes, it's an underscore, not dot or pop. You don't need to qualify it with the main form. UpRider >I am trying to call the itemnamecb afterupdate event from another open > form [quoted text clipped - 6 lines] > didn't help. > thanks for any suggestions Uprider Thank you. that worked and does exactly what i was trying to do. Thanks again, brc > I am trying to call the itemnamecb afterupdate event from another open > form [quoted text clipped - 6 lines] > didn't help. > thanks for any suggestions Call Forms("eventfrm").itemnameCB_AfterUpdate() Both forms must be open. The itemnameCB_AfterUpdate() must be declared Public  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.