Consecutive date in next record?

[Fi_McC]

I am building a Tour Booking Form and am trying to set the default value in the 'TourDate' field. I would like it to be the next consecutive available date from my 'TourDate' field in a table called 'CompositeKeySchedule'. I have previously done this using a =DateAdd ("d","1",DMAX()) expression in the default value in the form but cannot for the life of me remember how I wrote the DMax expression. Can anyone help? It has worked previously but I am going round in circles here!

 

[Isaac]

What have you tried?

 

[theDBguy]

Could it have been something like?

DMax("DateField","TableName")

 

[Fi_McC]

That is what I've been trying today, but it keep saying #Name? rather than inserting the next date. It is accepting the expression in the form properties but not returning the date. I have also had it saying #Type? when I tried a different selection of brackets....

 

[theDBguy]

That is what I've been trying today, but it keep saying #Name? rather than inserting the next date. It is accepting the expression in the form properties but not returning the date. I have also had it saying #Type? when I tried a different selection of brackets....

Okay, just a thought. Instead of entering it in the Table, try putting it on the Form.

 

[Fi_McC]

Do you mean to try using the Form name instead of the table name in the DMax function? I've started again and made a new table, query and then form incase I had gotten my wires twisted. I've attached a screenshot of the Query, and then of the Form and the expression that I have used in the form to create a default 'next date'. As you can see it is just bringing up the #Name! issue rather than inserting a date. I would really appreciate any help. Think I'm going mad...

 

[theDBguy]

Hi. I think you may be getting the #Name? error because of syntax error in your DMax(). Maybe try this instead.

=DateAdd("d",1,DMax("TourDate","SampleTourQ"))

 

[Fi_McC]

You are a modern day marvel. Works like a dream. Thank-you so much!

 

[theDBguy]

You are a modern day marvel. Works like a dream. Thank-you so much!

Hi. Glad to hear you got it sorted out. Good luck with your project.