rrtpeds
05-20-2008, 09:26 AM
I am trying to create an update query that when run will simply ask in a seperate box similiar to using this line on the criteria line of a select query
Like "*" & [Enter any char to search by: ] & "*"
When i run the above code in a select query it asks me what records i want to pull. I need to create something similar in an update query that will ask what the new data i want to replace all records old data with. Eg if my new start date was 5/14/2008 I would want access to come up with a box that would ask new date, I would place in the new date and the computer would run the query. Also tried using a copy/paste method from an unbound form but once inside the query it says that go to control isn't available any ideas?
Like "*" & [Enter any char to search by: ] & "*"
When i run the above code in a select query it asks me what records i want to pull. I need to create something similar in an update query that will ask what the new data i want to replace all records old data with. Eg if my new start date was 5/14/2008 I would want access to come up with a box that would ask new date, I would place in the new date and the computer would run the query. Also tried using a copy/paste method from an unbound form but once inside the query it says that go to control isn't available any ideas?