Information not transferring between tables

[Grahamiwa]

I have an Inventory and Sales database built from a template I found.
Inventory is recorded in an Inventory Transactions table with fields for product and quantity.
Sales are recorded in a sales detail table with similar fields.
When I enter a sale through the Sales Detail sub form it is not recorded in the Inventory Transaction table.
In design view the detail in the event tab for both product and quantity is all blank.
I looked at the Visual Basic and there are 2 procedures listed for product and quantity.
On changing the After Update to [Event Procedure] I end up with a Visual Basic compile error User-defined type not defined.

I can't seem to get a photo off my phone onto this post so excuse any typing errors.

The procedures are identical except for their name.

Private Sub Combo6_AfterUpdate()



Dim IT As InvenyoryTransactions
IT.ProductID = Me ! [Product ID]
IT.Quantity = Me ! [Quantity]
IT.AllOrNothing = True
IT.InvenyoryID = Nz(Me ! [Inventory ID],NewInventoryID)

In the debugger the IT As InventoryTransactions is highlighted.
I have the Inventory Transactions table name exactly as in VB but it still fails.

What can I do to get this working?

[orange]

Access does not have a datatype called InvenyoryTransactions.
Here is an M$oft reference to datatypes with Access.

I have responded to your other post with some suggestions that apply here as well.
Good luck.

[CJ_London]

I can't seem to get a photo off my phone onto this post so excuse any typing errors.

just copy and paste your code, then use the code tags (highlight the pasted code and click the # button). Always better to copy/paste/code tag - much easier for users to respond and more importantly, avoids typo's.

[davegri]

It appears that you don't have your UDT (User Defined Type) defined.
You can put it in an existing code module or create a new one. If new, name it mdlMyType.
You need this at the top of the code module:

Option Compare Database
Option Explicit

Type InventoryTransactions
    ProductID as long
    Quantity as long
    AllOrNothing as boolean
    InventoryID as long
End Type

However, without seeing your DB, I don't know if just correcting this error will accomplish your end goal of adding the record data. You probably need to post the DB here for analysis.