 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Update Form
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 Nancy, In your code to open the reoport, use a Refresh just before the OpenForm.  Signaturehth 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." > 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 [quoted text clipped - 10 lines] > > Thanks 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 > Nancy, > In your code to open the reoport, use a Refresh just before the [quoted text clipped - 13 lines] > > > > Thanks 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/microsoft.public.access/browse_frm/thread/129230d 6666d6fe6/a76ba388babc7e2a Tom Wickerath Microsoft Access MVP http://www.accessmvp.com/TWickerath/ http://www.access.qbuilt.com/html/expert_contributors.html __________________________________________ > 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 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. > Hi Nancy, > [quoted text clipped - 20 lines] > > > > Thanks for your help 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 __________________________________________ > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.