 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008Form leaves table recordset open
I have a simple database but a problem I can't figure out. Objects are: 1) Table A. 2) Form A, used as a front-end tool for data entry for Table A. 3) Button on Form A which drives data to temp tables using queries and performs further calculations. 4) Report in Print Preview showing finished calculations. Problem is: after tabbing off the last field in the form, Access is leaving that recordset open for further entry or editing. Consequently, none of the queries work because no data is saved in the table. How do I get Access to close that recordset? I've tried using gotorecord next, but since the table isn't actually open, that just causes another error. Vanessa, You aren't giving enough information to answer this. Is this a bound form? Is the recordsetclone being open? It sounds like you are tabbing to a new record before you click your button. Open your form in designview. Open the property sheet for the form. Set the Cycle property to "Current Record" on the drop down list. God Bless, Mark A. Sam >I have a simple database but a problem I can't figure out. Objects > are: [quoted text clipped - 11 lines] > gotorecord next, but since the table isn't actually open, that just > causes another error. > Vanessa, > [quoted text clipped - 25 lines] > > - Show quoted text - Thanks - it's a form bound to a table - really just a front-end data entry tool. What i'd like to be able to do is to have the user tab off the last field in the record and then click a calculate button. however, the form is leaving the record open for editing (ie, it has the pencil symbol in the corner, as if it's waiting to complete some input)- - that means that none of the data entered pass through to the queries and scratch tables that perform the calculations. Vanessa, In the last control (or any data control for that matter) place this line in the AfterUpdate event of the control: DoCmd.RunCommand acCmdSaveRecord This will update the form's underlying table. God Bless, Mark A. Sam On Apr 4, 11:19 am, "Mark A. Sam" <MarkA...@EmEssEn.Com> wrote: > Vanessa, > [quoted text clipped - 30 lines] > > - Show quoted text - Thanks - it's a form bound to a table - really just a front-end data entry tool. What i'd like to be able to do is to have the user tab off the last field in the record and then click a calculate button. however, the form is leaving the record open for editing (ie, it has the pencil symbol in the corner, as if it's waiting to complete some input)- - that means that none of the data entered pass through to the queries and scratch tables that perform the calculations. > Vanessa, > [quoted text clipped - 55 lines] > > - Show quoted text - WORKED LIKE A CHARM! thankx!!!! |
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.