Record not saving when expected

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a form which is looking at records for different people. It's pretty simple, it has the navigation buttons on the bottom to move from record to record. When I am adding a record and fill in the first field on the form and tab out of it the ID of the new record displays in a textbox at the bottom of the form. That textbox is tied to the ID field in the associated table. The ID is an autonumber field.

When I move to another record, the new record I just left is not immediately saved in the table. As a matter of fact, it is not saved until the form is closed.

I thought that moving from any record to another record would 'save' the previous record if it had either been edited or it was new.

That's not happening and I'm running out ways to troubleshoot why it isn't saving. Any ideas on what may keep it from saving to the table?
 
Perhaps you can explain why you think the record is not being saved to the
table.

I have a form which is looking at records for different people. It's pretty
simple, it has the navigation buttons on the bottom to move from record to
record. When I am adding a record and fill in the first field on the form
and tab out of it the ID of the new record displays in a textbox at the
bottom of the form. That textbox is tied to the ID field in the associated
table. The ID is an autonumber field.

When I move to another record, the new record I just left is not immediately
saved in the table. As a matter of fact, it is not saved until the form is
closed.

I thought that moving from any record to another record would 'save' the
previous record if it had either been edited or it was new.

That's not happening and I'm running out ways to troubleshoot why it isn't
saving. Any ideas on what may keep it from saving to the table?
 
On this form there is a combo box which I requery and the item does not
appear in the combo box

SO

as a troubleshooting aid, I tabbed out of a control and noted that an ID was
available on the form then switched to a query on the table and the item is
not saved in the table. I also checked when I moved from the 'new' record
to another record, ran the query and still no save in the table. As soon as
I close the form, the item does finally save to the table.

Karen

Perhaps you can explain why you think the record is not being saved to the
table.

I have a form which is looking at records for different people. It's pretty
simple, it has the navigation buttons on the bottom to move from record to
record. When I am adding a record and fill in the first field on the form
and tab out of it the ID of the new record displays in a textbox at the
bottom of the form. That textbox is tied to the ID field in the associated
table. The ID is an autonumber field.

When I move to another record, the new record I just left is not immediately
saved in the table. As a matter of fact, it is not saved until the form is
closed.

I thought that moving from any record to another record would 'save' the
previous record if it had either been edited or it was new.

That's not happening and I'm running out ways to troubleshoot why it isn't
saving. Any ideas on what may keep it from saving to the table?
 
Back
Top