I am at a loss to truly explain it; however In short, I cannot update an access database table as the error I recieve says that ...
An Error occurred in Step 6C: Updating the Details Database Table
Error Number: 5
Description: You cannot add or change a record because a realted record is required in table 'CO ID Master'.
I use this code to try an tell me what is going on:
MsgBox("An Error occurred in " & PBText & Chr(13) & Chr(10) & Chr(10) & "Error Number: " & Err.Number & Chr(13) & Chr(10) & "Description: " & Err.Description & Chr(13) & Chr(10), MsgBoxStyle.OKOnly, PBText)
I have it designed that two (Master and Detail) data grids get populated when an error occurs; when I compare the offending detail data line (marked with a red "!") there is corresponding data in master table. I have a screen shot that shows that both are in each.
So can someone tell me what is going on?