Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stop form automatically adding record

Status
Not open for further replies.

Haldane

IS-IT--Management
Mar 13, 2002
18
NZ
How do I stop my form automatically adding a record?.
I want my form to check that 2 figures are the same before adding the record.
I tried adding an after_update procedure that checks the check number with a calculated control figure, if the 2 are the same then then a save record button appears. If the 2 numbers are not the same then a message appears giving up the option to fix a keying mistake or cancel adding the new record.
The procedure does bring up the save record button but it has already updated the record and it is displaying the next blank record.
 
Try in the before_update section. After update is too late.
 
mas5,

Thankyou that worked.

I have just got to make it popup now if you try an cancel half way through entering the record.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top