J
Jim Scarlett
I'm new to access and VB and don't understand the following: I set the record
source for a sub form to one of 3 SQL statements depending on a user's
selection in 1 of 3 combo boxes on the main form.
Records are displayed correctly in the subform and (without writing any
'insert' or update code) I can edit all non identity fields on existing
subform records. But when I try to add a new record Access goes into a panic
and either bombs out entirely or tells me that a 'key value for this row has
changed and local row is now deleted'
Why does access allow edits to records but not new ones (I've set the cursor
to adUseClient ) If i need to write an 'insert' query where (in what event ?)
should i put it?
source for a sub form to one of 3 SQL statements depending on a user's
selection in 1 of 3 combo boxes on the main form.
Records are displayed correctly in the subform and (without writing any
'insert' or update code) I can edit all non identity fields on existing
subform records. But when I try to add a new record Access goes into a panic
and either bombs out entirely or tells me that a 'key value for this row has
changed and local row is now deleted'
Why does access allow edits to records but not new ones (I've set the cursor
to adUseClient ) If i need to write an 'insert' query where (in what event ?)
should i put it?