Update Query to run on SELECT records in table

A

Andy

I have a form with two sets of data in, running from one table. I would like
a button that would give the user the ability to update dataset 2 with the
information in dataset 1 on an individual record basis for each page on the
form

Basing this button on a simple update query, updates all dataset in the
ENTIRE table. Is there someway I can build into the query that it only
updates the dataset fields for the one record that it is looking at?

Perhaps more a form question, but can clarify if this does not make sense.

Thanks
 

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

Adding data to MS Access from csv file 0
Prevent Query Update until I press refresh button 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Query button in form 3
Merging Multiple Tables With Same Fields into Single Query 4
Basing a query on the selection in a Combo box parameter 2
How do I clear a form? 0
large dataset/import problems 5

Top