Can't save record via my subform 1

[annsolomon]

I have an unbound main form that uses a tabbed subform with several pages (e.g., Work Orders, Contacts, Faxes, etc.). Each page has a Save command button on it but the one on the Faxes page doesn't want to work. I keep getting Error #0 with no error description although my error trapping code requests a description. I've tried both of the following lines of code but neither seems to work. Any ideas?

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

DoCmd.RunCommand acCmdSaveRecord


Ann

 

[danvlas]

Put an Exit Sub before the error trapping routine label.
Otherwise it will be always executed, which actually happens: it trapped error 0 (which is the error code for 'No Error' )

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[annsolomon]

Good grief! I did forget the exiting. Thanks for saving me from myself Daniel.

Ann