Hi Guys
I have a query that has the following code
UPDATE POSurvey SET
NewTSSRRxPlanCompDate = IIF(SurveyComAd IS NOT NULL,dateAddWeekday(SurveyComAd,1)),
NewTSSRSuPlanCompDate = IIF(TSSRRxComAd IS NOT NULL,dateAddWeekday(TSSRRxComAd,1)),
NewTSSRApPlanCompDate = IIF(TSSRSuComAd IS NOT NULL ,dateAddWeekday(TSSRSuComAd,1))
WHERE PODate IS NOT NULL;
How do I get this query to not run on ALL the records in the POSurvey table but only on the current record in a form. My form is called frmPOSurvey The idea is that as soon as either SurveyComAd, TSSRRxComAd or TSSRSuComAd are updated then the query would run on only the record that is currently selected.
I get it to run on all the records but just need it to run on the current record in the form.
Could you please explain what the best option would be, a function, or some other solution. It could even be on a button that the user clicks after they enter the dates.
Also it would be greatly appreciated if the Code Syntax could be given.
Thanking you in Advance