update a record with specific data thru a query 1

[julius1]

in my database I have records that may be in several lines. I have a delete query that can remove it, but I am trying to get it to an update query that will prompt me for the data to put in it's place on all of the occurances. I have a search field to locate all of the occurances of the specific record, I am trying to place a command button to launch the query or macro that will update all occurances with "ASR 123456". To date I have had no luck, I even tried doing a multi macro ont he button. I can do the update query but how can I get it to prompt me for the data I want to replace it with? For example:
I can locate circuit id 01/xxxxx/xxxxxxxx, and it will pull up all occurances. On that screen I want to place the command button that will let me "delete" the record, but in actuality do an update query for all records that match that ID, and promt the user for the order number that took it out. Anyone have any ideas? I am lost on how to get the update query to prompt me for the data to replace the entry with.

 

[Beejay57]

I havent tested this but i think you would
add a new field in the query
ReplaceData:[ask the user]
in the field that you want to update use
[ReplaceData]

when the query is run it will prompt for
the value of [ask user],the user supplies the answer

hope this helps

 

[julius1]

That is the bomb!!!! Thanks a lot!