Requery problem

  • Thread starter Thread starter lemes_m
  • Start date Start date
L

lemes_m

I tried requery in macro and also docmd.requery but both of commands
sometimes work and sometimes don't. Few days ago everything was fine
but I changed tables structures and since then I have this situation.
Any suggestion?
 
In code, be specific about what you need to requery.

Also, save first. The requery won't succeed if the current record cannot be
saved.

If Me.Dirty Then
Me.Dirty = False
End If
Me.Requery
 
I have two forms: one for adding new records (form1) and one which
shows all records (form2). The problem is form2 which I can not
requery.

For example when I add new record in form1 I save record, close form1
and try to requery form2 from code or manually using built in function
from ms access but there is no result.

Datasource for form2 is stored procedure with parameters. I mention
that everything was just fine few days ago but then I changed some
table structures and I got this problem.

Also, I need to mention that everything is OK when I open stored
procedure directly.

Also, there is a problem with summing in forms.
 
If you have 2 forms referring to the same data, and you can edit in both
forms, you are setting yourself up for concurrency problems.

To requery a form named Form2, use:
Forms![Form2].Requery

If you have summing problems as well, you may have made some other
detrimental changes as you say.
 
Back
Top