none
Dynamically pass parameters into update query RRS feed

  • Question

  • When I have a form close, on close, I want to run a update query that will pass in the accnum from my form into a table with that matching accnum into the criteria of my update query, so I can update a particular field in that table with the matching accnum.  Is that possible?

    Wednesday, November 11, 2015 3:33 PM

Answers

  • I figured it out - I think.  In my query I added to the accnum criteria in my update query to read =[Forms]![mainForm]![accnum].  It looks like it is doing exactly what I want.  Thanks for looking at my question.
    • Edited by seebert Wednesday, November 11, 2015 4:26 PM
    • Marked as answer by seebert Wednesday, November 11, 2015 5:31 PM
    Wednesday, November 11, 2015 4:25 PM

All replies

  • Is your query stored as an object or just SQL in a procedure?
    Wednesday, November 11, 2015 3:53 PM
  • It is store as an object.
    Wednesday, November 11, 2015 4:05 PM
  • I figured it out - I think.  In my query I added to the accnum criteria in my update query to read =[Forms]![mainForm]![accnum].  It looks like it is doing exactly what I want.  Thanks for looking at my question.
    • Edited by seebert Wednesday, November 11, 2015 4:26 PM
    • Marked as answer by seebert Wednesday, November 11, 2015 5:31 PM
    Wednesday, November 11, 2015 4:25 PM