0

enter image description here

There is a Store list forms which contains Open Date, Store Number.

After the Open Date is updated, I want to open popups like below.

enter image description here

And If I click yes, I want to update the target date which has the same store number as in the Store list. But I don't know how to connect the store number data from Store list to here. I use ms access web app.

Scarlett
  • 173
  • 12
  • Maybe use SetValue macro action if you want to edit field of current record? What is 'Store list' - a combobox? Run a SQL UPDATE action with dynamic parameter that references the combobox? – June7 Jul 14 '17 at 18:48
  • "Store List" is a form which contains lots of data. I add the photos. Where is SetValue macro action or SQL UPDATE action? I can't find any?? – Scarlett Jul 14 '17 at 19:13
  • I meant an SQL UPDATE action query object which would be run with OpenQuery macro action. Or use RunSQL macro action to execute an SQL statement. Click on "Show All Actions" on the macro design tab to reveal SetValue and RunSQL. – June7 Jul 14 '17 at 21:12
  • @June7 Seems like it is just for the desktop version..not for the web app..! – Scarlett Jul 17 '17 at 14:53
  • Unfortunate. I don't use macros and never built web app. Why save TargetDate? Can it be calculated when needed? What determines the target date? – June7 Jul 17 '17 at 16:49
  • @June7 I had the macro that will calculate the target date automatically,(DateAdd(Day,-([varOpenWeek])*7,[varOpenDate])). like this. I want to use this macro when the user says "yes". But seems like there is no way to bring the Open Date data at the store list to the new forms which is asking "Do you want to update the Target Date?". – Scarlett Jul 17 '17 at 18:39
  • Is this what TempVars are for? https://social.msdn.microsoft.com/Forums/office/en-US/5e8a3452-1d1e-4ab6-8d85-f17c641419cc/tempvars-in-access-2013-web-apps?forum=accessdev – June7 Jul 17 '17 at 19:10

0 Answers0