Lorna
April 2nd, 2001, 05:46 AM
hi
Access 2000 - I've got 2 forms - linking them with a command button. I don't want either of them to commit data to the database if there was a problem in either - I'm not sure how to do that. Obviously, after filling out the first form, update event occurs. Same with second - so if there is a problem on the second form, the data on the first has already been captured on the DB.
How can I control this - I've heard of begintrans etc, but I'm sure how to implement it on TWO forms at once
thans
Access 2000 - I've got 2 forms - linking them with a command button. I don't want either of them to commit data to the database if there was a problem in either - I'm not sure how to do that. Obviously, after filling out the first form, update event occurs. Same with second - so if there is a problem on the second form, the data on the first has already been captured on the DB.
How can I control this - I've heard of begintrans etc, but I'm sure how to implement it on TWO forms at once
thans