data doesn't commit when pasted into subform datasheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The paste works, but the data doesn't commit until some sort of action is
taken - I don't know exactly what type of action commits the data, but a
"remove filter" will do it.

When the data commits, it "falls" out of view, and the subform returns to an
"empty" waiting to add a record state. I suspect this is because there are
no master/child links.

The query behind the subform is CUSTOMERS table (PK autonumber) and a
sub-class SPOUSE table (FK, no PK) with a one-to-one relationship.

The subform has no master/child links because the user will be pasting in
new customers, not data related to a specific customer.

Can anyone explain what I'm seeing here? and how do I get the data to
commit immediately after the paste?

Thanks.
David Mueller
 
The actions that you can take are the following:
Press F9
Click the Save Icon
Choose Save from the Menu
Resort the data
Apply a filter
Remove a filter
Close the Form
Close Access
Click on a subform
Press the Page Down Key
Press the down arrow from the last control
Press the tab key from the last control
Ctrl+home
Ctrl+End
Home
End
Look at Access funny
Sneeze

I wonder if I forgot any??
 
Thanks. I've been looking funny at this all day, and I'm the one that will
get committed! :)

Seriously, those are a lot of options, but none are transparent to the user.
Is there some code I can place behind an event?

Also, I just noticed that when I paste records, the last of the records is
never populated with the data that should be there... the last pasted record
is always blank. Something screwy is going on.

Any additional thoughts?
 
Back
Top