M
Martin Dashper
How can I refresh an open, bound form to reflect changes made to the
underlying table?
Martin Dashper
underlying table?
Martin Dashper
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Moving from one record to the next will display updated data from records in
the table.
Are you asking how to include new fields or changes to the underlying table
structure? If so, you would need to go into design view and update the
form. Adding a field to a table, changing the field edits, etc. are not
reflected in the forms bound to that table.
Rick B
the table.
Are you asking how to include new fields or changes to the underlying table
structure? If so, you would need to go into design view and update the
form. Adding a field to a table, changing the field edits, etc. are not
reflected in the forms bound to that table.
Rick B
M
Martin Dashper
No, I am not attempting to change the structure of the table, just theMoving from one record to the next will display updated data from records in
the table.
Are you asking how to include new fields or changes to the underlying table
structure? If so, you would need to go into design view and update the
form. Adding a field to a table, changing the field edits, etc. are not
reflected in the forms bound to that table.
Rick B
data.
I have a tabular form bound to a table and when I delete records via
code they show, on the form, as '#deleted' despite having moved away
from the 'deleted' record and performing a '.update'. Also, the form
does not display new records although the table does.
If the form is closed and then reopened the changes are displayed
correctly.
In case it is relevant, I am manipulating the data using a 'dynaset'
with an SQL query string and DAO3.6.
Martin
D
Dirk Goldgar
Martin Dashper said:No, I am not attempting to change the structure of the table, just the
data.
I have a tabular form bound to a table and when I delete records via
code they show, on the form, as '#deleted' despite having moved away
from the 'deleted' record and performing a '.update'. Also, the form
does not display new records although the table does.
If the form is closed and then reopened the changes are displayed
correctly.
In case it is relevant, I am manipulating the data using a 'dynaset'
with an SQL query string and DAO3.6.
From code on the form:
Me.Requery
From code on some other form or in an independent module:
Forms!NameOfForm.Requery
M
Martin Dashper
Perfect. Thanks very much.From code on the form:
Me.Requery
From code on some other form or in an independent module:
Forms!NameOfForm.Requery
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
Martin