Requery a Table after a record has been Deleted using a Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is an easy question for you guys...! I'm using a 'Tab' control that has
on (Page 1) a form that uses a table (in the current DB) as the
'recordsource' for the form so I can 'add/change' table records with the
preset navigation properties. On (Page 2), I use a form populated with a
query from this table for a 'specific' field item. I then may 'delete' this
record from the same table using a 'DELETE ...' query using a command button
on the (Page 2) form. When I go back to my (Page 1) to add/change a record
to the same table, there is now '#deletes' for the controls where the deleted
record information use to be... You can tell me if I am wrong, but I believe
this is due to the record now not being in the 'instance' of the table that
was being used for the (Page 1) form's 'recordsource'. So, I need to
'requery' the table so as to use the 'updated' table...

I'm not able to find an appropriate solution to requerying this table for
use on the (Page 1) form!! Thanks in advance...
 
Thanks for the response! When I tried doing this, it did work, but there was
'fluttering' occurring (I think due to each record being loaded-not sure).
Is there a way to have the 'requerying' being nice and smooth? I can get it
to work nicely if I use another 'button' control (on the form) and reset the
form's recordsource property, but I think you should be able to set the
software to do this nice and smooth (i.e., when the Title control gets the
'focus') so you don't have to remember to requery the underlying table with
changes...
 
Back
Top