I have created a button that activates an update query. The update query updates a date field in my database with the NOW date function. The update query's criteria is the ID field from a list I made in a form referencing the same table that the date is in. The ID field is an autonumber.

For some reason, the update query works for any other criteria columns in the list, eg. style number, team, etc. but it will not update if I set the criteria to ID.

Is there some rule in Access that is preventing me from using the ID criteria?

Thanks,

Alex

The update query will only work for the bound value in the list. My list had several different columns, but the bound value was set to 1, which is the first column, "style #", which is why style number worked and nothing else did. I changed the bound value to 5, the column of my autonumber, and it worked.