A
Alan
How do I refresh the table of a form when it is active ?
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.
J
John Vinson
How do I refresh the table of a form when it is active ?
What is "it"?
What do you mean by "refresh the table"?
A
Alan
Sorry,
I have a main form have text boxes showing the fields of a record, then
another button like 'Edit current record', it pops up a form and I do the
editing, close that form and return to main form.
I want the main form refreshes reflecting the new data.
I have a main form have text boxes showing the fields of a record, then
another button like 'Edit current record', it pops up a form and I do the
editing, close that form and return to main form.
I want the main form refreshes reflecting the new data.
J
John Vinson
Sorry,
I have a main form have text boxes showing the fields of a record, then
another button like 'Edit current record', it pops up a form and I do the
editing, close that form and return to main form.
I want the main form refreshes reflecting the new data.
Requery the main form in the Close event of the popup form:
Forms![mainformname].Requery
It will move the form back to the first record unless you store the
Primary Key of the record before you pop up the form, and find it
afterward.
A
Alan
I am using the table rather than query for the main form.
How do I refresh the table ?
How do I refresh the table ?
John Vinson said:Sorry,
I have a main form have text boxes showing the fields of a record, then
another button like 'Edit current record', it pops up a form and I do the
editing, close that form and return to main form.
I want the main form refreshes reflecting the new data.
Requery the main form in the Close event of the popup form:
Forms![mainformname].Requery
It will move the form back to the first record unless you store the
Primary Key of the record before you pop up the form, and find it
afterward.
J
John Vinson
I am using the table rather than query for the main form.
Even if the Form is based directly on a Table, you can Requery the
form; doing so will check for new information in the table and display
it. Access actually creates a hidden query for you as the recordsource
of the form, for that matter - all Forms are based on queries anyhow!
G
Guest
How do I make a calculation on two form entries and have that calculation update to the main table
Expample: Sales Entry Cost Entry Gross Profit ( Sales - Cost
Thank You
Expample: Sales Entry Cost Entry Gross Profit ( Sales - Cost
Thank You