Table refresh

[Alan]

How do I refresh the table of a form when it is active ?

 

[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"?

 

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

 

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

 

[Alan]

I am using the table rather than query for the main form.
How do I refresh the table ?

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.

 

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

 

[Kevin]

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