Refreshing bound form?

[Martin Dashper]

How can I refresh an open, bound form to reflect changes made to the
underlying table?

Martin Dashper

 

[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

 

[Martin Dashper]

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

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.

Martin

 

[Dirk Goldgar]

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

 

[Martin Dashper]

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)

Perfect. Thanks very much.

Martin