Open a form with choice of data sources? (1 Viewer)

R

Rachel Crosby

Guest
I would like to use one form, but depending on the type of payment being made, have the data source for the form be one of
several tables (identical table structures, but from different fiscal years). The user would, by responding to a pop-up box
prompting for fiscal year, be calling one of the tables. The table names all are in the same format, e.g., RETRAN98,
RETRAN99, PPTRAN98, PPTRAN99, etc., so that only the first and last two characters vary from name to name. Any help
with the VBA code would be greatly appreciated. Thanks in advance.
 

Users who are viewing this thread

Top Bottom