Me.refresh form

[as]

Hi All,
I am working on a Access to ADP SQL server conversion project.On one of
the forms I need to add a record which gets stored in a temporary
table. But even after i delete the record from the temporary table the
Me.refresh function does refresh the form. And it still has the deleted
record on the form.But me.Refresh does work fine in the origibnal mdb
application.

If anybody can help me on this I would be greatful.

Thanks in advance!!

sd_naive

 

[Sylvain Lafontaine]

Try with Me.Requery.

Instead of deleting it directly on the server, you can also try to delete
the record locally and then save the recordset so that the record will be
deleted on the SQL-Server side.

S. L.

 

[as]

Hi Sylvain,
Thanks for you reply!
I did try the Me.requery option but it does not work. The form does
show the deleted record on it enen though the record has been deleted
from the temp table on the server.

I could not get the deleted record locally functionality. Do you refer
to the cloning of the recordset approach.

thanks
sd

 

[Sylvain Lafontaine]

The Me.Requery command didn't work?!

This indicates that we are probably misunderstanding something about your
current situation. Possible causes:

1- There is no primary key.

2- The form is not bound to the temp table but to another table.

3- You are using some kind of unbound form.

Probably, you will have to give us some more informations about exactly what
are you doing presently before we can understand what's happening.

S. L.