Ok. So if it is in the same list, you can add another data connection to query the list. You could probably set the query to not run when the form opens (this is a checkbox toward the end of the dialogs when you set up the data connection) and then set the query field to the value you wish to look for on your button click, followed by a rule to run the query. After that rule, you could add another rule with a condition that the number of items in the returned data fields (for this same data connection) are equal to zero, set the field you wish to update.... Hope that makes sense?
Hilary Stoupa
