Prompt in Update Query asking for data to update

[mjhopler]

I am trying to build a query that sets a parameter to determine which fields up update, and then be able to enter the data to update.



For example, the Table has field Class Number and Time Required to Teach In Hours.
I have an update query in the Class Number field Criteria is a parameter [Enter Class Number]. I am trying to get the same type of prompt that can ask for number of hours. It would then find the records that match that class number and update based on number of hours entered.

I currently have the criteria for Class number as [Enter Class Number] and set the Update To: field for Time Require to Teach to [Enter amount of time]. this did not work. Any suggestions?

[mjhopler]

Nevermind, it did work. I was mistyping the parameter and thus it was not updating any records. User Error.

thanks