I am not sure what the issue is now.

mmcdonal

I added the iStart and iEnd and removed the on current event, but the result is still the same. When I choose a value in either one of the combo boxes, the other one updates itself to the same value...

Can you email me the database as a zip file, if there is not any private data in it?

mmcdonal

I can send it to you if you want... I think I still have your email from a previous time you helped me. I'll send it to you later today and explain everything in detail to you again...

Seems like I'm not going to send you the file, because it is possible that the person I'm making this for wants to change something. Not working with weeks anymore, but with dates... So I prefer to wait instead of giving you some work that may be done for nothing... They have seen what has been done so far and will give me a final answer on monday or wednesday of next week...

What I just like to know is:
If they change this and work with dates instead of weeks, is it possible to change the startweek and endweek into startdate and enddate and then make a code that does the following:
take the startdate and the artikelnumber to create a first record, then take the stardate +7 days with the artikelnumber to create the next one and then always add 7 days until it matches the end date?

So if I take 02/05/2007 as the startdate and 02/26/2007 as the enddate with artikelnumber 25 it would create this in the table:

   Date Artikelnumber
02/05/2007 25
02/12/2007 25
02/19/2007 25
02/26/2007 25

The primary key will be the combination of both date and artikelnumber.

I don't know if this would change much to the code you gave me...