If i have another request out there regarding this same issue please disregard it as i cant find it to get to it. and if its there please just mark it solved when really it isnt so we dont get these 2 confused..thanks :-)
Here is the code as it stands now..
Code:
Private Sub Product_ID_AfterUpdate()
'Initialize price and discount for each product change
If Not IsNull(Me![Product ID]) Then
Me![Quantity] = 0
Me.Quantity.Locked = False
Me!
[List Price] = DLookup(IIf(Forms![Order Details]!TypeID = 1, "
[List Price A] ", "
[List Price B]"), "Products", "ID=" & Me.Product_ID)
Me![Status ID] = None_OrderItemStatus
'Empty Product records mean user wants to delete line item
Else
eh.TryToRunCommand acCmdDeleteRecord
End If
End Sub
This is what it looks like in Design View..
this is what it looks like in Form View..
Now my issue...
When selecting Product it needs to also brings up the Poduct Code too. Now if i am not providing the correct info at the above please let me know what you need. I am also attaching copy of my DB but i can not save it to an earlier version other than Access 2010 for anyone to view it.
Database54.zip
TIA
Stephanie