store database using combo box

Hi Friends...

I attached a file. its working good. Some implementation i need. in this form (frmfilter) now i newly joined combobox7. Its need to load 1 to 31 (date Purpose)..


First i select Duty. then i select date. then i double click the listbox1(employee Select).

Its go to store in allotment page.

at the same time another copy of the data need to store in attendance sheet.

if i select 15 in combobox7. that time attandance sheet 17 column under employee duty details (eg: D - Duty, N - Night) need to insert.

Please Help ME

So is this correct

I select a Duty example "N"

Then i select a number in combobox list (no list yet be say) 15

then in column 17 (number 15) in the attendance sheet i will put "N"

......

Where do i get the employee number from and when does this action happen? do they need to select something in the large listbox first before being allowed to change these comboboxes...... are they required fields?

Thanks
Paul S.

Here with i attached updated.... in this is i coded mostly but one problem... in the form i selected duty , date, month (only January Select).

then i double click the listbox value to pud duty of my staff.

THat time in the january sheet selected date . but not put duty on selected person. thats only problem.

at the same time in the january date 1 i selected. (if in case) already some duty put on that time. i need to filtered data on listbox1 and 2.

Listbox1 that time populated. empty cells only. listbox2 populate d,n, ot, c,etc... only. (its very important).

Please Help Me Friends...

I tried. but still didn't complete. Please help