Form leaves table recordset open

I have a simple database but a problem I can't figure out. Objects
a

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


"Vanessa" wrote in message
...
I have a simple database but a problem I can't figure out. Objects
a

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.

On Apr 4, 11:19*am, "Mark A. Sam" wrote:
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

"Vanessa" wrote in message

...



I have a simple database but a problem I can't figure out. Objects
a

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.- Hide quoted text -

- 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

"Vanessa" wrote in message
...
On Apr 4, 11:19 am, "Mark A. Sam" wrote:
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

"Vanessa" wrote in message

...



I have a simple database but a problem I can't figure out. Objects
a

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.- Hide quoted text -

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

On Apr 15, 2:30*pm, "Mark A. Sam" wrote:
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

"Vanessa" wrote in message

...
On Apr 4, 11:19 am, "Mark A. Sam" wrote:





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

"Vanessa" wrote in message

...

I have a simple database but a problem I can't figure out. Objects
a

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.- Hide quoted text -

- 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.- Hide quoted text -

- Show quoted text -

WORKED LIKE A CHARM! thankx!!!!