Update Form

[Nancy]

My purchase order form is now working great. I have designed a report to
show the purchase order information and it works great. The question I have
now is this:

When I enter the info into the form and the hit the preview form button, the
info is not on the record. If I enter the info into the form and save the
form info and then hit preview report, the info is there on the report. How
can I make the purchase order form save the info when I enter it without
having to manually save each and every record.

Thanks

 

[Al Campagna]

Nancy,
In your code to open the reoport, use a Refresh just before the
OpenForm.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Nancy]

Thank you for your response. I used the command button wizard to preview the
report. When I go to design view and click on the Event procedure button it
brings up the Macro window. How do I put refresh in there?

Thanks for your help

 

[Tom Wickerath]

Hi Nancy,

Are you possibly using Access 2007? The reason I ask is that the command
button wizard in Access 2003, and all prior versions, created VBA code; it
did not create a macro.

You need to commit (save) the record before opening the report. One way of
doing this is to check the .dirty property of the form, and force it to false
if it is true (setting dirty to false saves the record). Check out this
recent thread:

http://groups.google.com/group/micr..._frm/thread/129230d6666d6fe6/a76ba388babc7e2a


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Nancy]

Thank you. I scratched my head for a few minutes trying to figure out where
to put the code but I got it. Copy and pasted uder the dirty command on the
properties. Changed the name of the report in the code and then saved
everything. Added a new purchase order and then hit the print preview for
the form and there it was. Thanks so much.

 

[Tom Wickerath]

Glad you got it to work!


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________