First of all, I'd like to start out by saying I'm new to this forum. Also I am somewhat skilled in programming and dabbling in Access. Currently I have a massive database that holds manufacturing inspection data. There are multiple dimension (as in measurement) tables linked to the 'Inspection form' along with a master table that holds things like quantity, date received etc... The 'supplier lot number' is the primary key and the reference point between these mulitple dimension( part measurement) tables. The database is shared between 2 plants and the data itself is held in Oracle. Some of our multiple part suppliers use the same lot number method (such as the julian date) and deliver to both plants. I'd like to append the 'part number' to the end of the 'lot number to solve this issue. So I put in some VB code to deal with it in the 'after update' event. The problem is I'll get a cannot insert null into <whatever> table #1400. I'm sure it's something rather simple - any ideas? If I need to I can attach the database itself (of course the data will be missing as it's on the local server). Let me know.
Here's the code:
Private Sub SUP_LOT_NUMBER_AfterUpdate
Dim COMPLEX_ID As Variant
COMPLEX_ID = (Me.SUP_LOT_NUMBER & "-" & Me.ctlPartNumber)
Me.SUP_LOT_NUMBER = COMPLEX_ID