469,150 Members | 1,955 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

Why code won't run in Field Event Properties?

112 100+
I have code for running an update query that updates a field in a table. I would like to have it run when I change or add information to a field in my main form. If I put the code into a button it works fine but when I put it into my event properties for that field it will not run? I have tried in on After Update and On Change (which I thing would be the place to put it) but nothing happens? Am I doing something wrong? Code is below.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.SetWarnings False
  2.     DoCmd.OpenQuery ("qrySortOrder2")
  3.     DoCmd.SetWarnings True 
Mar 10 '11 #1
1 1215
112 100+
Sorry figured it out... have to add it to the Forms after update not the text box!
Mar 10 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Lachlan Hunt | last post: by
1 post views Thread by | last post: by
11 posts views Thread by Sarah | last post: by
2 posts views Thread by puzzlecracker | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.