Get and Set the data in a table using a macro?

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

Guest

I would like to use a macro to get the data in record one of a source table
and then use that data as the criteria for a search query. Then I would like
to get the data in the second recond of the source table and use it as the
search criteria in the query. Looping thru the table and seting the queries
criteria to the new value until the last search is complete. Can a macro be
used to do this?
 
You can get data by query results for form textbox. That textbox can be the
criteria for the next query. You could flip back and forth between
query/formss. There is a limit of 20 for calling the same macro. So you
will probably need code to do the looping.

To what end are you doing this?
 
Back
Top