Hi, I am a relatively new Access programmer, but have programmed computers in Fortran and done complex modeling for years. Am learning quickly, and have managed to figure everything out so far, but now am stuck. Sorry if this is a basic question. I am using Access 2007.
I have a form for data entry. Database is biological samples. One table has sample code, date, other fields. Another table has multiple records for each sample, with species measured within each sample. I am setting up form for entering data on more samples. I have set up form with subform. User enters sample code, program checks (referential integrity) to be sure it is a valid sample. Subform is where user views or enters the species measured within each sample. Everything is working fine for data review. But when I enter a new sample code that has no child species records, instead of giving me a subform with just a blank record ready for data entry, it gives me one of the existing records where it has substituted the new sample code for the sample code that had been in that record.
Would appreciate help or suggestions on where to look.
I have a form for data entry. Database is biological samples. One table has sample code, date, other fields. Another table has multiple records for each sample, with species measured within each sample. I am setting up form for entering data on more samples. I have set up form with subform. User enters sample code, program checks (referential integrity) to be sure it is a valid sample. Subform is where user views or enters the species measured within each sample. Everything is working fine for data review. But when I enter a new sample code that has no child species records, instead of giving me a subform with just a blank record ready for data entry, it gives me one of the existing records where it has substituted the new sample code for the sample code that had been in that record.
Would appreciate help or suggestions on where to look.
Comment