A
Atlas
..Adp project, WinXp + SP1, Access 2003 (11.5614.5703) + MS SQL Server 2000
+ SP3
* Table A:
[ID A] int 4 (Identity = yes, primary key)
MyTimeStamp timestamp 8
[Date] datetime 8
Description varchar 50
* Table B:
[ID B] int (Identity = yes, primary key)
MyTimeStamp timestamp 8
[ID A] int 4
Description varchar 50
Fieldx money 8
Fieldy money 8
* Continuos form master (A), rowsource "SELECT" based (A->date range),
updatable snapshot
* Continuos subform child (B) rowsource (B), updatable snapshot
* REMOVED ALL THE VB CODE IN BOTH FORMS.
1) Run the form
2) enter into field description (existing record)
3) make some changes
4) "exit" field (update occurs OK)
5) Do something else (navigate trough form)
6) Goback to previuosly modified record
7) Repeat steps 2,3
8) Exit field (update invoked ->Write Conflict - "This record has changed by
another user since you started.......", Save Record, Copy to Clipboard, Drop
Changes)
Any help appreciated
+ SP3
* Table A:
[ID A] int 4 (Identity = yes, primary key)
MyTimeStamp timestamp 8
[Date] datetime 8
Description varchar 50
* Table B:
[ID B] int (Identity = yes, primary key)
MyTimeStamp timestamp 8
[ID A] int 4
Description varchar 50
Fieldx money 8
Fieldy money 8
* Continuos form master (A), rowsource "SELECT" based (A->date range),
updatable snapshot
* Continuos subform child (B) rowsource (B), updatable snapshot
* REMOVED ALL THE VB CODE IN BOTH FORMS.
1) Run the form
2) enter into field description (existing record)
3) make some changes
4) "exit" field (update occurs OK)
5) Do something else (navigate trough form)
6) Goback to previuosly modified record
7) Repeat steps 2,3
8) Exit field (update invoked ->Write Conflict - "This record has changed by
another user since you started.......", Save Record, Copy to Clipboard, Drop
Changes)
Any help appreciated