I have a form that retrieves one record. When I change the data and then click the Save Command, and the message triggers a SQL update event, using a Where statement matching [userID] or [SubID] (both in the original Query), all records are updated instead of just the one. I thought the [variables] syntax refered only to result variables. On the other hand, if I use @fmrSubID as a match in the Where statement (it's displayed on the form and visible under variables), nothing gets updated.

I'm sure it's something simple I don't see. Thanks.

Updates all:
UPDATE Lynx_sub
SET
VacationEndDate=@frmVacationEndDate, VacationStartDate=@frmVacationStartDate
WHERE SubID=[SubID]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Updates none

UPDATE Lynx_sub
SET
VacationEndDate=@frmVacationEndDate, VacationStartDate=@frmVacationStartDate
WHERE SubID=@frmSubID

You can pass in the message Action [SubID] value.

{Action,[SubID],Save,,Message}

In the xy variables you can declare a variable by selecting "Message" in the dropdown and Source "Save" and Target @Save.

In the Message actions query

UPDATE Lynx_sub
SET
VacationEndDate=@frmVacationEndDate, VacationStartDate=@frmVacationStartDate
WHERE SubID=@Save


Hope this solves your problem.

My results is that I get no update. Here are the settings:

the save button:
<A class=CommandButton {ACTION,[SubID],Save,,Message}>Save
</A> | 

Under y=x I have

<Message> Save @Save

Under Action I have 2 actions:
1)
Message: Awaiting incoming message with Type '' and Value 'Save'.
2)
# Execute Query[Update]: UPDATE Lynx_sub SET VacationEndDate=@frmVacationEndDate, VacationStartDate=@frmVacationStartDate WHERE SubID=@Save

I get no update to the table.
Is there any way to debug and see the action query result like you can on the main query?

For your Message listener (Item 1 in your list of Actions), I believe you want to specify Type=Save, and leave Value blank (it will hold the SubID you specified in the anchor).