Add record to multiple tables

[rickscr]

Here's what I need to do:

I have a table for storing sample information. For a given sample, I need to generate 5 records in the sample table. In each record, all of the fields will be the same except for one.

For example:

SampleID	SampleDate	SampleLocation	SampleMethod
1	1-Jan	SiteB	Method1
2	1-Jan	SiteB	Method2
3	1-Jan	SiteB	Method3
4	1-Jan	SiteB	Method4
5	1-Jan	SiteB	Method5

I want the user to enter the date and site, and click a button to add all 5 records. The Methods added will always be the same 5.

I imagine there is some way to do this in VBA or a macro, but I haven't been able to figure it out.

[ajetrumpet]

you can simply run an append sql statement 5 times behind the button's click event.

do you know how to do that??

or....if that doesn't sound good, make a table with 5 records in it, and write two lines of code behind the button: one for updating fields in the 5-rec table, and one for appending the entire table to a new table.