know I know..you saw who is posting and think..SHE's Baccckkkk!! lol and here i was doing so good too!
Here is the Issue:
In the Order Subform for Order Details I needed to remove one field and insert another - -
The Field I need is Product Code under the Products table to which added from the recordsource on the Ordersubform for Order Details to get it from Products
the one field i did not need was "Unit Price" so i removed it.
Now the field i do want to have in there is called Product Code.. The fields should be in the order of the following:
Product ID
Product Code
Oty
List Price
Status ID
It used to be the following
Product ID
Qty
Unit Price
Discount
Status ID
With previous posts I was able to figure out and change from "Discount" to List Price and have it get the correct info into that field..that isnt the issue..here is the issue...
Now i am getting this debug error..
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![Unit Price] = 0
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

So I removed Me![Unit Price] = 0 and then all the rest started turning yellow too! It not allowing me to add the new field in to which by the way its in the wrong column in the form too from where its at in the table/query to which i keep trying to change the tab source to get the column in the correct format too...but other than that please tell me what i am doing wrong
TIA
Stephanie