I am trying to reinvent our inventory database to allow for more efficient data entries.
I have created a form titled frmInventoryAdd.
In the form header section, I have unbound fields for NomenclatureIN, PNIN, PriceIN, ReceivedIN, and ConditionIN.
In the detail section I have fields derived from my Inventory Table for Nomenclature, P/N, S/N, Price, Condition, and Comments.
My goal here is for the user to type into the unbound fields, and have all of the fields excluding the S/N be automatically filled in from the unbound fields. The S/N (serial numbers) are unique to each device, so that is why the user would enter them in individually. The remaining fields are all common for the entry event.
I added the follwoing to the after update for the unbound fields:
__________________________________________________ ______________________________________
Private Sub ConditionIN_AfterUpdate()
Me!Condition = Me!ConditionIN
End Sub
Private Sub NomenclatureIN_AfterUpdate()
Me!Nomenclature = Me!NomenIN
End Sub
Private Sub PNIN_AfterUpdate()
Me!PN = Me!PNIN
End Sub
Private Sub PRICEIN_AfterUpdate()
Me!Price = Me!PRICEIN
End Sub
Private Sub ReceivedIN_AfterUpdate()
Me!Received = Me!ReceivedIN
End Sub
__________________________________________________ _____________________________________
This works flawlessly for the first item s/n entry, but not for any additional entries. I enter the unbound data, then add s/n for the first item, but the next line does not autopopulate when I tab through to it.
Any help would be greatly appriciated!