ESC key is the only way to Save the Record?

[cw]

I'm having a very strange issue here: The only way to save my record is to
hit the ESC key?

- I have a Tabbed Form on my Main form, with Subforms on each Tabbed Page.
- The Main form is based on tblBids
- The Tabbed forms are all based on Linked Tables/Detail Table to allow for
Many to Many.
- When I create a new record, the Main form data will not save until I hit
ESC?
- Once done, I can then enter the Subform data but cannot save that until I
hit ESC?

I do not understand what is going on here?
I have the correct relationships, correct tables, and my subform Link
Master/Child fields are correct.

I have always seen the ESC key clear my current "un-saved" record, but this
is the first time I have encountered something like this. (I'm using Access
2007)

Here is the link to the Relationships:
http://cerberus.clearwave.com/jerry/WKI_Relationship.gif

Thanks for any help,
cw

 

[Allen Browne]

Unless you have redefined the Esc key to mean something non-standard
(through an AutoKeys macro, or a Keyxxx event), it undoes the current
control/record.

The fact that it appears to "save" the record would suggest that you have
something that is dirtying the record as soon as it is saved. This might be
something in the AfterUdpate, AfterInsert, or Current event of the form.

To help debug it, I suggest you set the form's Record Selector property to
Yes. When the record is dirtied, you will see that the icon in the Record
Selector becomes a pencil instead of a side-ways triangle pointer (or star
at the new record.) You therefore have a visual indicator of when your form
is dirty. If it is dirty when it should not be, you have verified that the
Esc is serving the function of undoing something that should not be
happening in the first place.

 

[cw via AccessMonster.com]

Allen, You are the king of Access! Of all the Access forums I have searched
and sought answers, your name is consistently the "best of breed" when it
comes to providing answers & real solutions and you always do so in such a
polite way.

Do you ever get tired of helping? (I hope that you get duly compensated in
your real job whatever that might be)

Anyway, You were right on as always! I had left some AfterUpdate code in my
main form & I was just about ready to throw out the whole Tabbed interface
and start over.

Thanks again, Allen
cw

Unless you have redefined the Esc key to mean something non-standard
(through an AutoKeys macro, or a Keyxxx event), it undoes the current
control/record.

The fact that it appears to "save" the record would suggest that you have
something that is dirtying the record as soon as it is saved. This might be
something in the AfterUdpate, AfterInsert, or Current event of the form.

To help debug it, I suggest you set the form's Record Selector property to
Yes. When the record is dirtied, you will see that the icon in the Record
Selector becomes a pencil instead of a side-ways triangle pointer (or star
at the new record.) You therefore have a visual indicator of when your form
is dirty. If it is dirty when it should not be, you have verified that the
Esc is serving the function of undoing something that should not be
happening in the first place.

I'm having a very strange issue here: The only way to save my record is to
hit the ESC key?

[quoted text clipped - 25 lines]

Thanks for any help,
cw

 

[Allen Browne]

Great! Glad you have it sovled. Feedback appreciated.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Allen, You are the king of Access! Of all the Access forums I have
searched
and sought answers, your name is consistently the "best of breed" when it
comes to providing answers & real solutions and you always do so in such a
polite way.

Do you ever get tired of helping? (I hope that you get duly compensated in
your real job whatever that might be)

Anyway, You were right on as always! I had left some AfterUpdate code in
my
main form & I was just about ready to throw out the whole Tabbed interface
and start over.

Thanks again, Allen
cw

Unless you have redefined the Esc key to mean something non-standard
(through an AutoKeys macro, or a Keyxxx event), it undoes the current
control/record.

The fact that it appears to "save" the record would suggest that you have
something that is dirtying the record as soon as it is saved. This might
be
something in the AfterUdpate, AfterInsert, or Current event of the form.

To help debug it, I suggest you set the form's Record Selector property to
Yes. When the record is dirtied, you will see that the icon in the Record
Selector becomes a pencil instead of a side-ways triangle pointer (or star
at the new record.) You therefore have a visual indicator of when your
form
is dirty. If it is dirty when it should not be, you have verified that the
Esc is serving the function of undoing something that should not be
happening in the first place.

I'm having a very strange issue here: The only way to save my record is
to
hit the ESC key?

[quoted text clipped - 25 lines]

Thanks for any help,
cw