Dynamic table naming?

  • Thread starter Thread starter Judy Rudek
  • Start date Start date
J

Judy Rudek

I have a menu with 12 buttons. My intention is to have each of those
buttons pass an argument to the next form, to tell it which table of
data needs to be viewed. The 12 tables are identical in structure,
but for reasons I don't want to go into here, must remain separate
(i.e., I can't just use queries to view different subsets).

Here's what I mean:

Pressing button "cmd01" will open form "frmDataDisplay" populated by
data from "tblTable01".
Pressing button "cmd02" will open form "frmDataDisplay" populated by
data from "tblTable02".

.... and so on.

Does this make sense? Can it be done?

Any assistance appreciated.

-- Judy
 
You can use the OpenArgs parameter of the form, and then change the record
source for the form using the value from OpenArgs.
 
Back
Top