Query using a users input in Access 97

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to run a query that is prompted by a users input..... IE: a
messagebox that asks for an order number. and after a number is typed in by
the user a query will run on that particular number... Specifically an
update query that will take all of the records with that order number and
insert them into another table.
 
What you need is referred to as Parameter Query. You can read more about it
on the help pages. Your query criteria for order number could be: [Enter an
Order Number]. Then you will receive that prompt at runtime.

Sal
www.ctgtraining.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table query: [Enter 1] AS Test 1
Pull a field from a form to be the criteria of an append query 0
Why Query works from table but not Query 3
SUM in a UNION query 2
Hard coding query works, code using form data does not. 3
Query based on multiple parameters - Access 2003 1
Access 2007 - check for existing record 1
User input of numbers 7

Back
Top