Query using a users input in Access 97

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.
 
S

Sal Rosario

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

Page numbering with Merged Document and IF statements 1
Make table query: [Enter 1] AS Test 1
Autonumber field in Excel that behaves the same as Access 0
Error in Access Query 0
QBF & Query Malfunction 0
Adding data to MS Access from csv file 0
Query using a users input in Access 97 0
query to show where no data in a stated column 0

Top