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
 
Back
Top