#Deleted in all fields

[Guest]

I'm using sql 2000 and Access 2003. I have a form that's record source is a
query. I have a drop down field AssignedTo. After you select a name I use a
Select Case Yes/No that asks if you want to assign another record. Selecting
No closes the form.

The problem I'm having is when Yes is selected. I'm using the following code:

Case vbYes
Me.Recordset.MoveNext
Me.DateAssigned.SetFocus

When Yes is selected I get #Deleted in all the fields in the form. I'm
thinking that this has something to do with the fact that the record source
is a query but I can't figure out how to get around it.

Anyone have any ideas?

Thanks for the help,

Paul

 

[Guest]

Nothing wrong with those lines of code, you may get an error if you are
already on the last record in the recordset, but that wouldn't show #deleted
in the fields, I suspect their is another line of code somewhere causing your
problem, perhaps in the On_Current or Before / AfterUpdate events of theForm
itself?

TonyT..