Add all records in the continuous form to the table (Bulk Entry)

[SBBmaster09]

I have a continuous form where when I select the dropdown it will update all the fields, then I filter team field it will only select that team then hitting the Save command, it will enter all the details in the table at once. It will record each line in the continuous form to the table.

Process Flow:
1] The form opens with all the names from a query (continuous form)
2] Filter the Team from the dropdown and will only show members from that Team
3] Will select status either Holiday or Vacation Leave
4] Select date on where to apply
5] Save button to add all the names with the Team name, selected status and date.


It was kinda bulk saving instead of one by one. What can be the possible code for the Save button to enter all the records to the table.


Any help appreciate on this, Thanks,

 

[Ranman256]

it would run an update query to mass update your data from the list in the sub-form,
using the same filters as critiera.

 

[SBBmaster09]

How can I do this? I dont have any idea from the scratch. Thanks.