Hello
I want a field called Deal Executed to be changed to Yes or No depending on the data in the numerical field Price Executed whenever a user entered a new record. Deal Executed is a combox box in the table itself (Yes/No), and I put an If statment in the AFter insert property that If Price Executed = "0" then Deal Executed = "No". It updates it, but when I go to close the form, it gives me a dialog box that MS Access had problems updating the database, and all my data may not be saved so do I still want to close the form. It still updates it though. The funny thing is that this used to work earlier, but after I added many additional fields and recreated the form from wizards, and added the code, it doesnt work now (i.e it gives the error). My form is in datasheet view. My old forms still work with no errors! Its very strange - does anyone have any clue why this is happening and any ideas on how to resolve it?
Thanks!
Shazia
I want a field called Deal Executed to be changed to Yes or No depending on the data in the numerical field Price Executed whenever a user entered a new record. Deal Executed is a combox box in the table itself (Yes/No), and I put an If statment in the AFter insert property that If Price Executed = "0" then Deal Executed = "No". It updates it, but when I go to close the form, it gives me a dialog box that MS Access had problems updating the database, and all my data may not be saved so do I still want to close the form. It still updates it though. The funny thing is that this used to work earlier, but after I added many additional fields and recreated the form from wizards, and added the code, it doesnt work now (i.e it gives the error). My form is in datasheet view. My old forms still work with no errors! Its very strange - does anyone have any clue why this is happening and any ideas on how to resolve it?
Thanks!
Shazia