Make table from a form

[thegameoflife]

How would you go about making a table from a form based on option buttons?

Lets say there are 5 option buttons on the form. If option buttons 1,3,5 are selected I want the new table to have only columns 1,3,5.

I HAVE NO CLUE!!

 

[dpimental]

In the vbcode behind each button, write the Append ("insert into Query&quot.

That gives you the freedom to chose the columns you want included in the new table.

David David Pimental
(US, Oh)
dpimental@checkfree.com

 

[thegameoflife]

that sounds good.

on my first post i tried to simplify it a little. I'm trying to create "dynamic" reports off a form. with the new table created I'm going to do a transfer spreadsheet with the data in the new table. Or query.

opt1 = [MEMBER]
opt2 = [DATE]
opt3 = [DOB]
opt4 = [GENDER]


if the user selects opt1,2 and fills in a date in a date box I want to make a table or create a query that a docmd.transferspreadsheet can use.

 

[dpimental]

If you want dynamic reports, you might want to change the onclick event to ....

1. Open the report.
2. Set the Record source of the report to a given query.
(You might be able to even pass #2 to a global module).

I'm not sure what all you want to do.

David David Pimental
(US, Oh)
dpimental@checkfree.com