I am trying to write VBA that will do the following:
In the current record, we have several fields, but most important is the MapID Number field. we use this field to track our map productions. We have a 2nd field called "Superseded" which we have to add in a new map number that will supersede the old map number.
What I am trying to do is create a routine where: In the current record (the new map record with new MapID number), the user clicks on icon, "Supersede", which calls up the inputbox and prompt them to enter the old map number to be superseded. Then the Access should add the new MapID into the old MapID record's "Superseded" field automatically.
Good question...I suppose. I can't seem to generate the error you are receiving. I transfers the ZIP file to several different computers and tried the sample on each of them. The sample worked fine on all systems with no errors.
Has anyone else experienced this problem?
You might try and start the sample DB while holding down the Shift key, then go into the Form's code module. While your there, see if you are MISSING any References (located in the Tools menu).
You might also make sure that in the VBE options (Tools|Options|Gereral Tab) that you have Error Breaking set to Break On Unhandled. I have it set to Break On ALL Errors and I still don't get an error.