Multiple record creation

[Jonno]

I have a form based on a main table. It stores records for staff attendance information, where 1 record = 1 day.

I have a list box which shows all staff on a particular shift as selected by a combo box. This has a select query as its source.

What I would like to do is when a button is clicked, the database builds a set of records, one for each person in the list box. Is there a way of creating multiple records in one hit, and each records Name field being updated with the different names in the list box? For example, the user selects Shift "1" in a combo box (Existing), and the list boxs shows Joe and Mark
- so 2 records can be subsequently created for those people, and then shown of the form.

hope this is clear..

 

[dcx693]

Yes, this is all possible with some not terribly complicated programming in VBA.

You need to have some code check the value in the combo box to find the Shift, then have the code go through and find all the selected entries in the list box, then have the code write those entries to your database table. You can then update the form to reflect those new entries.

 

[Mile-O]

It stores records for staff attendance information, where 1 record = 1 day.

Surely you should have 1 record being equal to 1 staff member per day.

 

[Jonno]

I did actually mean that, not what i wrote