Navigation Button by week

[Guest]

How would I create a next button that jumps from week to week. I have a form
that lists records for the entire year. When I press teh Next button, instead
of scrolling record by record, I wish to scroll week by week. The form has
already the week number (1-52) for all records

Thank you

 

[fredg]

How would I create a next button that jumps from week to week. I have a form
that lists records for the entire year. When I press teh Next button, instead
of scrolling record by record, I wish to scroll week by week. The form has
already the week number (1-52) for all records

Thank you

You state that you already have a WeekNumber field.
If that field is a Number datatype, then you can use something like
this. AirCode:

Dim intWeekNum as Integer
intWeekNum = [YourWeekNumberField] + 1
Me.RecordsetClone.FindNext "[WeekNumberField] = " & intWeekNum
Me.Bookmark = Me.RecordsetClone.Bookmark
[SomeField].SetFocus

 

[Guest]

I really appreciate the promptness of your response.
Thanks a lot
--
LeParis

How would I create a next button that jumps from week to week. I have a form
that lists records for the entire year. When I press teh Next button, instead
of scrolling record by record, I wish to scroll week by week. The form has
already the week number (1-52) for all records

Thank you

You state that you already have a WeekNumber field.
If that field is a Number datatype, then you can use something like
this. AirCode:

Dim intWeekNum as Integer
intWeekNum = [YourWeekNumberField] + 1
Me.RecordsetClone.FindNext "[WeekNumberField] = " & intWeekNum
Me.Bookmark = Me.RecordsetClone.Bookmark
[SomeField].SetFocus