Pre-poulate Subform with a row for each attendee

[d3adelvis]

Hi



I have a form called Workshop.

Main Form: WorkShop. ([WorkShopId] int, [WorkshopName] text, [WorkshopDate] date/time)
Sub Form: WorkShopAttendees ([WorkShopId] int, [EmployeeId] int, [Attended] yes/no, [ReasonId] int)

When a new WorkShop record is created, I want to populate the SubForm with:

AttendeeName
Attended? (Checkbox)
Reason (DropDown)

The checkbox will be ticked unless it is reported that the employee was absent (Annual Leave, Sick etc.)

The person who hosted the WorkShop will then check that the List is correct before hitting a button.

The button will insert all the subform data into the WorkShopAttendees table.

What is the best way of acheiveing this?

I don't need a full solution, just some pointers. Like how do I grab the WorkshopId if the record has not yet been saved?
Is it best to use a query or write some code and create a recordset? I even toyed with the idea of putting the results in a tmp table then doing the insert from there but couldn't grab the WorkShopId!

I can write SQL till the cows come home but my VBA skills are not the best.

Has anybody don a similar thing before? i have searched everywhere! Maybe my search terms are not the best.

Thanks in advance!

[pbaldy]

Presuming you have a table of attendees, you can execute an append query that gets the attendees from there and the ID number from the form. You may need to force a save of the record:

If Me.Dirty Then Me.Dirty = False