on a different form, I've got the below code (it works just fine)
on a new form, I'm using nearly the exact same text (adjusted for a different table...)
and even when at the last record in the tableif Rst.EOF returns "false"
HTML Code:
Dim rst As DAO.Recordset
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("SELECT * FROM tbeSubmittal")
If rst.EOF Then
strPrompt = "You are at the end of the database;" & Chr(13) & Chr(10) & "Do you want to create a new record? "
Response = MsgBox(strPrompt, vbQuestion + vbYesNo + vbDefaultButton1, "END of DATABASE")
<...>
perplexed (nevermind the curiosities of the Universe...)
but with many thanks in advance,
Mark