I created a simple SQL macro to update fields in my database, however, once I run the macro, access prompts me to enter paramater values, how do I get rid of the prompts or why are they occuring?
Check that you've identified your fields properly. If Access can't recognize where you're trying to get/put data, it usually thinks it's a [parameter] because the structure is the same (see above).