calculate dateout without weekend days in a form

[buddyr]

Hello,
I have a form.
When a user enters item number Date shipped field is filled with current date.
TurnAroundTime is a number field to add the number of days to Date shipped.

DatOut is an unbound textbox on form.
I want DateOut filled with Date shipped + TurnAroundTime.
The turn around time number is static and assigned to Item numbers.

I have tried creating a module and a call in the main form and subforms.
I cannot get the DateOut to display -Date shipped + TurnAroundTime.
I have tried making a field for DateOut also.

The form has already been created and I am modifying it. It has a thousand or so records.The DateOut field already has data in it.
I thought I would make a unbound textbox to display date and just enter it in DateOut field.
any ideas or suggestions?
thank you

[youmike]

It looks as if you should be using the "After Update" event attached to the control that you call "TurnAroundTime". If this is indeed so, don't forget to put the appropriate Requery, Refresh, Repaint after the calculation.

If you want to count weekdays only, you will probably have to include a Do/while loop to examine each day in the time period and count it if it is a weekday. This you would have to test using the Weekday function, counting the days only if the Weekday value is less than 6.

If you need to exclude public holidays as well, this would add another level of complication, which you would have to test by referring each date to a table of public holiday dates and excluding if there is a match.

A final thought - if you need to do this repeatedly, it might be worth writing code in a module, which could be used in a range of situations. In this case, you would need to pass parameters to and from the module using global constants.

[buddyr]

thank you,
unfortunately, I am hitting a block with the TurnAroundTime.I stumbled upon somthing like you said - using refresh- but then I had problems and still null values errors- main problem did not have handle on what I was doing.
can you be any more specific?
thank you

[buddyr]

am going to try to make a clearer question- thank you for your help here