I have a query, that runs when you push a button on my form. It is an update query. I want the user to be able to input one value, and it will take the value from a textbox for the other value. Here is the SQL for the query:
UPDATE tbl123 SET tbl123.status = [Enter Status]
WHERE (((tbl123.program)=[Forms]![form1]![ProgramName]));
The problem is, it prompts for status, but it actually won't write to the table?????