I have built a very simple inventroy tracking program and am having a problem with the form and subform.
I am trying to update my Units on Hand with a subform but can not figure out how to make the subform record advance to a new record when I enter data in it. For example I enter a new item in inventory and receive the amount in the subform. When I advance to the new record in the main form, the subform remains with the data from the previous record. I am a novice so I am very limited on my knowledge or how access works.
Attached is a copy of the file. If anyone has any ideas, they would be greatly appreciated.
Thanks
darrellx
I am trying to update my Units on Hand with a subform but can not figure out how to make the subform record advance to a new record when I enter data in it. For example I enter a new item in inventory and receive the amount in the subform. When I advance to the new record in the main form, the subform remains with the data from the previous record. I am a novice so I am very limited on my knowledge or how access works.
Attached is a copy of the file. If anyone has any ideas, they would be greatly appreciated.
Thanks
darrellx
