Have a look at Richard's Open Form video;
https://599cd.com/blog/display-article.asp?ID=1804
or Find Record Combo;
https://599cd.com/blog/display-article.asp?ID=2314

If you're opening it from a button, it would just be a matter of creating a "Where" string that checks if specific fields match the current date.

For example:

(adjust button "ReviewBtn" and field names "D45", "Wkly", "Mthly", "Yrly", to match your table/form)

Private Sub ReviewBtn_Click()

     Dim WhereString as String

     WhereString = "D45 = #" & Date & "# " & _
          "OR Wkly = #" & Date & "# " & _
          "OR Mthly = #" & Date & "# " & _
          "OR Yrly = #" & Date & "#"

     docmd.OpenForm "ScriptureMemoryF", , , WhereString

End Sub
Copy

Donald has the right idea. The easiest way is to open ScriptureMemoryF with a WhereCondition that filters the records to only those due today.

One important detail: if D45, Wkly, Mthly, and Yrly can contain times along with dates, an exact comparison to Date() may not match. In that case, use DateValue([FieldName]) = Date(), or better yet, store review dates without a time portion.

Once the form is filtered, it will automatically tab and navigate only through the records in that filtered recordset. You do not need separate code to skip the other 239 verses.

Bryan's OpenForm video will show you the mechanics of passing that filter in, and Donald's example gives you a good starting point.