manosalexo
New member
- Local time
- Today, 05:47
- Joined
- Jan 25, 2019
- Messages
- 6
Hello,
I have a situation.
I have built a form in which at the product's afterupdate event i have inserted the following:
Private Sub Product_AfterUpdate()
Me.Category = DLookup("[Category_table.Description]", "Query3", "[product_id]=" & Forms!order!Product)
Me.plaisio_idd = DLookup("[plaisio_id]", "Products", "[product_id]=" & Forms!order!Product)
Me.color_description = Null
Me.color_description.Requery
Me.color_description = DLookup("[color_description]", "Query1", "[product_id]=" & Forms!order!Product)
Me.Price = DLookup("[price]", "Products", "[product_id]=" & Forms!order!Product)
Me.measurement_unit = DLookup("[measurement_unit]", "Products", "[product_id]=" & Forms!order!Product)
End Sub
Now what i am trying to do is to Call that event from another afterupdate so that the user may either select the product, or enter the ID:
Private Sub plaisio_idd_AfterUpdate()
Me.Product.Requery
Me.Product = DLookup("[description]", "[Products]", "[plaisio_id]=" & Forms!order!plaisio_idd)
Call Product_AfterUpdate
End Sub
Now when i insert these lines of code, the debugger hits a 3075 error in my Product_AfterUpdate() code. If i remove plaisio_idd_AfterUpdate(), my Product_AfterUpdate works just fine.
Can someone please tell me what i'm doing wrong?
Thank you in advance
I have a situation.
I have built a form in which at the product's afterupdate event i have inserted the following:
Private Sub Product_AfterUpdate()
Me.Category = DLookup("[Category_table.Description]", "Query3", "[product_id]=" & Forms!order!Product)
Me.plaisio_idd = DLookup("[plaisio_id]", "Products", "[product_id]=" & Forms!order!Product)
Me.color_description = Null
Me.color_description.Requery
Me.color_description = DLookup("[color_description]", "Query1", "[product_id]=" & Forms!order!Product)
Me.Price = DLookup("[price]", "Products", "[product_id]=" & Forms!order!Product)
Me.measurement_unit = DLookup("[measurement_unit]", "Products", "[product_id]=" & Forms!order!Product)
End Sub
Now what i am trying to do is to Call that event from another afterupdate so that the user may either select the product, or enter the ID:
Private Sub plaisio_idd_AfterUpdate()
Me.Product.Requery
Me.Product = DLookup("[description]", "[Products]", "[plaisio_id]=" & Forms!order!plaisio_idd)
Call Product_AfterUpdate
End Sub
Now when i insert these lines of code, the debugger hits a 3075 error in my Product_AfterUpdate() code. If i remove plaisio_idd_AfterUpdate(), my Product_AfterUpdate works just fine.
Can someone please tell me what i'm doing wrong?
Thank you in advance