#deleted message on record

[SuzyQ]

I have a form that is used for prospective clients that contains minimal
client information and a button that will "activate" the client if desired.
When the user clicks on the activate client button, it takes the information
on the current record and inserts it in to the client table, and then deletes
the current record in the prospective client table. When the record is
deleted, I want to refresh the form so that the #deleted message is removed
and the record counter is recalculated, however me.refresh gives me an error
that the record has been deleted. How can I just move to the previous or
next record in the table and get off of the #deleted record?

Thanks for any help.

 

[SuzyQ]

actually me.refresh was not giving me the message, that was coming from
somewhere else, but how do I get off of the #deleted record and reset the
record counter so that record is skipped when the user is navigating the rest
of the records?

 

[Guest]

Do a requery on the form. I had a similar problem on a combo list, and
Duane Hookom pointed me in the right direction. See my posting date 1/26.

Bill

 

[SuzyQ]

Thanks, that did it. I don't know why I didn't think of it. I've used
requery before in similar situations.

Thanks again.