Clay,
The condition for my rule is...txt_RelmNumber (text box field) does not match custom pattern: AAAAA
The action is....txt_RelmName = @RELM_ID[concat(txt_RelmNumber, " ")= @RELM_ID]
Where....txt_RelmName is the value that the rule set's (on the form) @RELM_ID and @RELM_NME are values from the underlying query, and txt_RelmNumber is the value that the user enters into the textbox.
Does this make sense? Thanks Ed