Unbound text box with Consecutive value

[simon123]

Hi there,

I have a subform which displays information for events. The duration of our events vary, so you could have a 1 day event or a 3 day event over 3 different dates... and so on. I have created a form displaying the event details and in the subform, I can add the date and times of each day. What I would love, is to be able to have a label for each date, just showing "Day 1, Day 2... " etc.

Currently I placed the following in a text box, and it looked like it would work initially - but it doesn't and as I add days, the value in the text box goes all over the place

=IIf([Programme Date]<>"","Day " & [Form].[CurrentRecord],"")

Is there a straightforward way of doing this?

Pic below for visual reference. Many thanks for any help

[Gicu]

You can do that with a ranking query (see https://bytes.com/topic/access/insig...-ms-access-sql or google it for other examples) or better yet do it on a report using the runningsum property (see https://msdn.microsoft.com/en-us/vba...roperty-access).

Cheers,
Vlad

[NTC]

T

here is no straightforward way of doing this. Auto-Sequential numbering is very complicated in tables/forms.

The straightforward thing is to enter that value (offer a combobox selector to make easiest) into a bound field. i.e. the users have to number their days themselves.... anything else is a real chore.....

[simon123]

Thanks very much for your input both of you. I think i will redesign the form without it but create a report with the runningsum function.

Cheers

[Gicu]

Sounds great, good luck with your project!