I'm using Access 07. I have a form Employees based on a table of the same 
name. I also have a form Policies also based on a table of that same name.

Table Employees contains basic personal information on employees, while 
Policies contains insurance policy information. The policies table also 
contains some of the same info as the Employees table (name, DOB, etc ...) An 
employee may have multiple policies. 

On the data entry form Employees, the user enters the basic employee info 
(name, DOB, SSN, etc ...) then clicks a button to open the entry form for 
Policies. 
On the Policies entry form, there is a button (Update) that runs a macro 
that includes a series of queries to update the fields that are common to 
both tables where the SSN is the same. This works fine. Then the user can 
proceed with entering the individual policy information.

What I want to happen is that once the user updates the common fields (name, 
DOB, etc ...), I want the page to refresh so the user can see the updated 
information, making sure it all is there, before proceeding to enter the 
policy information. Currently, the user has to exit the Policies form and 
re-enter (or move to another record and come back) to see the updated info.

Is there a simple way to refresh the page once the macro runs the queries to 
update certain fields?

have you tried to bookmark your form and set the record back to the bookmark
after requery?

varBookmark = Me.Bookmark
DoCmd.RunMacro <yourMacro>
Me.Requery
Me.Bookmark = varBookmark


Rachael wrote:
>I'm using Access 07. I have a form Employees based on a table of the same 
>name. I also have a form Policies also based on a table of that same name.
>
>Table Employees contains basic personal information on employees, while 
>Policies contains insurance policy information. The policies table also 
>contains some of the same info as the Employees table (name, DOB, etc ...) An 
>employee may have multiple policies. 
>
>On the data entry form Employees, the user enters the basic employee info 
>(name, DOB, SSN, etc ...) then clicks a button to open the entry form for 
>Policies. 
>On the Policies entry form, there is a button (Update) that runs a macro 
>that includes a series of queries to update the fields that are common to 
>both tables where the SSN is the same. This works fine. Then the user can 
>proceed with entering the individual policy information.
>
>What I want to happen is that once the user updates the common fields (name, 
>DOB, etc ...), I want the page to refresh so the user can see the updated 
>information, making sure it all is there, before proceeding to enter the 
>policy information. Currently, the user has to exit the Policies form and 
>re-enter (or move to another record and come back) to see the updated info.
>
>Is there a simple way to refresh the page once the macro runs the queries to 
>update certain fields?

-- 
spread the WORD

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201001/1