Extra record created on table in Access
Posted on 2011-02-23
I'll start with the basics and provide more detail as needed. I have a table called ActiveCases that creates the header for a veterinary case. After creating a new record on this table via the bound ActiveCase form, the user then clicks "New Diagnosis" which opens a form in Add mode that is bound to a table called CaseTrtmt. Through openArgs the form inherits the activeCaseID and the locationID. After creating the related record in the CaseTrtmt table, the user clicks a back button that returns them to the related activeCase. It is at this point that for some reason Access creates a new record on the ActiveCases table that has no data other than the location field (which is a duplicate of the location stored in the previous record).
I realize this is not a lot to go on, but before posting all of the relevant code I thought I would first see if anyone has encountered a similar scenario and can perhaps list a candidate or two that I can investigate. I'm usually able to track these kinds of issues down on my own but this one has had me baffled for a few days.