I am using the following event in my MS Access order database to lookup the newest prices from my product table, and store them in the order records.
Private Sub ProductID_AfterUpdate()
’ Evaluate filter before it is passed to DLookup function.
strFilter = “ProductID = " & Me!ProductID
’ Look up product’s unit Price and assign it to the UnitPrice control.
Me![UnitPrice] = DLookup(”[Price]", “Products”, strFilter)
How do I do this on a Scriptcase Single record form?