Recent content by SRL

I thought about that, and in-fact, started down that road. I changed course, because I thought allowadditions made more sense. Maybe I shouldn't have....

I might be opening up a can of worms here but I appreciate your input. Is there a general coding preference for either using or not using docmds vs your codedb.execute? My intent for this project is ultimately to port the back end to a mysql db and use access as workstation front end within...

Update: Ok, so now we know that the condition causing the error is that on subforms2 and subform21, the AllowAdditions properties are set to false, except when we are adding records. I need to protect these subforms from users trying to add sample records if they have not selected a project...

Ok... now we are getting somewhere. When I set both subforms to allowadditions the form works wonderfully. now to figure out how to lock it down without throwing an error. I will report back.. Awesomeness...

You are absolutely correct. I have searched for actions that interact with fields bound to the recordset, but i haven't found them. I will look some more. I have the forms set for allowadditions = false. However, I change this condition to true before adding a record and after saving the...

No joy CJ... It still generates the exact same message. It makes me think that the error is not being generated within these two snippits of code, but rather within some other event code... but alas, the location of the offending code eludes me...

Thanks for the Tip CJ... I was aware of the stops and steps. I will try commenting out the error statements, but I am not sure I understand the rationale. I know error traps can sometime hide problems with the code, but can they cause them too? I know the error its generating, I just don't...

To add a little more to my question... Is it possible that the code generating the error may be in some other event sequence? I am not sure of the exact sequence of events that are triggered from the time I click the Delete button and the time I click any other control on the form. On the...

I am a first time poster on here, but have used this site regularly as a great resource to help me find answers to questions other folks have already asked. This time... I need help finding the problem in my own code. Backstory: I have an Access 2003 mdb front end connected to a similar back...