Changing column source of report based on input from a form.

[ghmag]

Hi, this is probably an easy question but I can't remember how to do
this.

I have a table with a primary key, and 4 data columns.

I have a form that has a combo box that lists out the names of all
four data columns, and a button to open the report. How do I open the
report using only the primary key and the data column chosen?

 

[RBear3]

What is in this table? If you are having to do that, you might have a
poorly designed table. If your field names contain data (March, April, May
or South Office, North Office, or John, Lisa) then you probably need to
rethink it. Your current setup would require you to rebuild your table and
your drop-down every time you need to add a new category (column).
Basically, you are "committing spreadsheet"!

There could be a valid reason for this setup, but I bet we could suggest a
better design if your share your structure with us.

 

[ghmag]

Yes, i can say my structure is one of things I spent a lot of time
thinking about and I couldn't figure out an easier solution.

Here's a sample of my table structure (there's actually a larger
number of Groups and Nodes).

Pri Key Option A Option B
Option C
------------------------------------------------------------------------------------------------
Node 1 Cable 1 Cable 2
Cable 3
Node 2 Cable 2 Cable 1
Cable 3
Node 3 Cable 3 Cable 2
Cable 1

The report is just a list of cables depending on what arrangement the
user wants to use.

 

[ghmag]

Yes, i can say my structure is one of things I spent a lot of time
thinking about and I couldn't figure out an easier solution.

Here's a sample of my table structure (there's actually a larger
number of Options and Nodes).


Pri Key Opt A Opt B Opt C
-------------------------------------------------------------------
N1 Cbl 1 Cbl 2 Cbl 3
N2 Cbl 2 Cbl 1 Cbl 3
N3 Cbl 3 Cbl 2 Cbl 1


The report is just a list of cables depending on what arrangement the
user wants to use.