When I am populating a new record, and click the "Spelling" button on the toolbar, the current record moves to the First Record in the table.
How can I prevent this?
The recordset is initially a disconnected one. Unsure if this has anything to do with it, so I'll summarise that process:
The form opens with DoCmd.OpenForm "frmJobDetails".
Recordset create like this... (only the important bits pasted....)
Code:
Set rs = New ADODB.Recordset
rs.Open strSQL, cn, adOpenDynamic, adLockOptimistic
With Form_frmJobDetails.Form
Set .Recordset = rs
.UniqueTable = "tblJobs"
.ResyncCommand = strResync
End With
DoCmd.GoToRecord acDataForm, "frmJobDetails", acNewRec
Form_AfterInsert() updates the resync command.
Code:
strSQL = Replace(strSQL, "WHERE 1=1", "WHERE JobID=" & Nz([JobID], "0"))
Me.ResyncCommand = strResync
Any advice would be greatly appreciated!