by Carlos1815 <Carlos1815@[EMAIL PROTECTED]
>
Aug 8, 2008 at 09:43 AM
Thank you for your response! I ended up figuring it out by doing
something similar:
'******************************************
Private Sub LastQuestion_Click()
On Error GoTo Err_LastQuestion_Click
Dim iMaxstg As Integer
iMaxstg = DMax("stg", "tblTopicTitle", "TopicTitle <> Null")
DoCmd.GoToRecord acDataForm, "TopicTitle", acGoTo, iMaxstg
Me.monyrtm.SetFocus
Exit_LastQuestion_Click:
Exit Sub
Err_LastQuestion_Click:
MsgBox Err.Description
Resume Exit_LastQuestion_Click
End Sub
I had to use the DMax function because the topics can be shuffled, so
I basically told Access to go to the biggest stg number that has
"something in it" and set Focus in that record.