Next Record Next Day

[sandylt]

1. I have a form that runs by the date. I want the next record to default to the next date. For example if today is 03/08/2006 then if a new record is created the next date will be 03/09/2006 and so on.

2. If that is possible I dont want Sundays involved. We do not deliver on Sundays.

 

[hootie318]

1. I have a form that runs by the date. I want the next record to default to the next date. For example if today is 03/08/2006 then if a new record is created the next date will be 03/09/2006 and so on.

2. If that is possible I dont want Sundays involved. We do not deliver on Sundays.

1. Put this in the DEFAULT on your form for the text box you want to update
=DMax("Date","[TableName]")+1
That will add one day from the previous day on record.

2. I would probably make a query with your dates and add the day next to the dates and have the query return all records for Monday - Saturday only. You might have to use the DMax function for the day as well to keep the day updating as well.

 

[sandylt]

I tried that and it works, except the day doesnt hold. If I go to a new record the date does go to the next day, but when I add records and close. When I come back there are no records under that date. Also the query on the days wont work because it raises the day to a number that doesnt exist.

 

[hootie318]

Maybe someone else can help, sorry.