Update record source

Search instead for. Did you mean:. All posts Previous Topic Next Topic. Labels: Labels: General Questions. Message 1 of 5. Accepted Solutions. Best Regards, Qi. Message 4 of 5. C-Papa Super User. Does it work if you change dropdownOppName. Title to dropdownOppName. Value or dropdownOppName. Message 2 of 5. In response to C-Papa.

Message 3 of 5. In response to v-qiaqi-msft. For a collection , the entire record must match. Collections allow duplicate records, so multiple records might match. You can use the All argument to update all copies of a record; otherwise, only one copy of the record is updated. If the data source generates a column's value automatically, the value of that column must be reaffirmed.

Use the UpdateIf function to modify one or more values in one or more records that match one or more conditions. The condition can be any formula that results in a true or false and can reference columns of the data source by name. The function evaluates the condition for each record and modifies any record for which the result is true.

To specify a modification, use a change record that contains new property values. If you provide this change record inline with curly braces, property formulas can reference properties of the record that's being modified. You can use this behavior to modify records based on a formula.

Similar to UpdateIf , you can also use the Patch function to change specific columns of a record without affecting other columns. Both Update and UpdateIf return the modified data source as a table. You must use either function in a behavior formula.

When used with a data source, these functions can't be delegated. This works well for Table as Record Source, but for Query, the criteria will add to the original Query, so you have to use Method 1 or 2. Suppose we have a headcount Report template, but we need to send each department a separate Report.

It is time consuming to maintain one Report template for each department, instead we can write VBA to change the department criteria so that we only need to maintain one Report template.