I have a problem on a form when I issue the Me.Requery command on a button click event on the form.
Even though I then use DoCmd.GoToRecord , , acFirst
the first time it tries to access the record e.g. Me.Recordset!CoinType
it gives an error saying there is no current record (there is one record as shown by Me.Recordset.RecordCount)
Note that this only happens when there is only one item in the record set (both before and after the requery). With multiple items it seems to work without a problem.
Is the Requery confusing the database somehow?