#Deleted When Record is Saved

[ahmadrashid17]

I have MS Access Interface connected to a backend of SQL Server.
I have designed forms for data entry which is working fine. When the user enter the data and click the wizard based generated save button, it saves the record and display "#deleted" in text boxes.

But if the user close the form and reopen it, the record is displayed correctly.

How to tangle this problem.

 

[ajetrumpet]

type this on an event:

me.refresh
  me.requery

that'll fix it.

 

[ahmadrashid17]

Thanks alot.
After that, how can i set the current record view to the inserted record, as requery will bring the first record in display.

Regards

 

[ahmadrashid17]

i solved by calling the method of last record button

thanks alot