My specific question has to do with a confusing database issue I have. I have 2 databases, one functions properly, The other, not so much.
Within Bowling4Answers.odb , the form ALLEYS utilizes a pair of MACROS to populate a field named NUGGET_NUM in Table ALLEYS by joining a text string (a preconfigured text box with three options) with the auto-incrementing primary key. It seems to work just fine.
Within ECR-ECO.odb, the form frm_ORIGINATOR(16) is attempting to use a similar field/structure as NUGGET_NUM named ECx_NUM. This form is set to allow additions, but not allow modifications or deletions, so one the form is submitted, the values are not editable (this is intentional as a second level reviewer will make any edits). This is the db I am having problems with getting the ECx_NUM populated.
The Error I am getting is an “Inadmissable value or data type. Overflow.” but I don’t know how to find the problem. The 2 macros that Ratslinger has provided are awesome, I can not thank him OR her enough. I have attached both db’s to refer to… Thank you in advance.