Add new record with some current record fields carried over

[isaacski]

Hi All,
I have a pretty simple db that currently has one main data table with things like Employee name, class, class date, scores, etc. I am trying to make a form where my trainers can add a new "roster" of people when a new class starts. (These will record to the main table and then the trainer can later open another form that displays all of the records for score input, etc.).

Right now I have a form that displays Trainer Name, Class Name, Class Start Date, and Employee Name. When a trainer goes to put in all of the names for the roster, the first three fields will stay the same. I want to have a button that when clicked opens the next record but fills in the first three fields based on the selections made from the current form.

I'm open to VB or Macro... any help would be appreciated!!

Thanks!

 

[pbaldy]

Try

http://access.mvps.org/access/forms/frm0012.htm

 

[isaacski]

I figured it out based on some logic I've learned from you in previous posts .

I created the form from the table with the fields I needed (trainer, class name, start date, employee name). I then created a new query with the same fields. On the query, the Trainer, Classname, and start date fields have the criteria that is matched to the cbo boxes on the form...

i.e. Forms! Name of the form! Name of the cbo

I then created a report from this query. I put the report in the form as a sub report so that every time I set the cbo boxes to either a new class or previous class the report displays the roster of whoever matches the dropdown values.

The Employee name is the only thing in the details section, the subreport is in the footer, and the trainer;class;startdate fields are in the header. I have a VBA set up to keep the three cbo fields the same on each new record. The report section updates with any new addition with the press of a button.

Sorry for anyone reading this if it doesn't make sense... for a newb that was a lot to crank out in 8 hours and it left me a bit fuzzy... pm me if you need more specifics!!

Thanks to Pbaldy for sharing the knowledge it took for me to figure this one out!