Refreshing bound form?

M

Martin Dashper

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

Martin Dashper
 
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
 
M

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top