Code is adding an extra record every time

[mooreb55020]

so I didn't test this until i got to adding more purchased good into the system and unfortunately it's adding everything into it as 3000001 and the last product line i have is 3000016 for that line. I looked through the code it's the same as the one you added above. the only thing i can imagine is that it doesn't start with "0" or it can't find the reference. I'm not sure.

[davegri]

mooreb-davegri-v02.zip

See attached.
Had to add query qProdLine. Code behind form is based on the query instead of tProducts. Query pulls all fields from tProducts and just Code from tblProductLines.
Had to change data type of Code in tProductLines table from short text to number.
Changed VBA behind form a bit to use the new query and productline Code field.

This confusion might not have happened if the field name (ProductLine) in tProducts had been named ProductLine_FK. This would have instantly identified the field as a foreign key pointing to the ProductLine table and not an application data field.

[mooreb55020]

Thanks, I will keep that in mind as i build more of this project in access. Again, Never used it before so learning all the tricks with it is coming from youtube, udemy and this forum. I'm sure i'll be posting a ton of questions about Access as i go as well and you all have been a tremendous help with this topic!

[davegri]

I'm sure i'll be posting a ton of questions about Access as i go

The good folks here are always willing to help with almost anything. Good luck with the project!