Need a macro to pause for user input

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

Guest

I am setting up a macro to run a query that finds records, and copies them to
another table. I want to have the user select which records from the
returned set to copy.

Anybody know how to do this?

PLEASE HELP!!!!
 
add a checkbox field to your first table

have the returned set be the record source for a new form - but also on this
form present the check box field with each record also

then - your next process i.e. button that triggers macro/append query,
etc...can be based upon "if checked".....

(and you will need to be sure to add a process that will return the check
boxes back to empty....)
 
I don't want to copy ALL the records that the search may return; I want to be
able to choose a single record from the search
 
right - that is the purpose of the the checkbox field in your table....

each record now has a checkbox field which is always empty

you run your first query with your results - but now there is a checkbox
field for each field

your user checks the record(s) that they want - now that/those records in
the table have X

then you run a second query but this time have the criteria of the query for
only those with X checkboxed - and it will return only those records....

finally behind-the-scenes you need to run an update query that will blank
out all checkboxes so you start fresh next time....
 
Back
Top