wizcow
Registered User.
- Local time
- Yesterday, 22:59
- Joined
- Sep 22, 2001
- Messages
- 236
Hi
My Inventory form has StockTakeDate and IDNumber.
The InventorySub form has the Parts data including Quantity.
On another form I am trying to use a DLookUp function to look up the part's last Invnetory date.
=DLast("[StockTakeDate]","[Inventory]","Form.[ItemNo]=[ItemNo]")
This doesn't work, probably because it does not reference the Sub Form.
How can I re-write this to make it work?
Tom
My Inventory form has StockTakeDate and IDNumber.
The InventorySub form has the Parts data including Quantity.
On another form I am trying to use a DLookUp function to look up the part's last Invnetory date.
=DLast("[StockTakeDate]","[Inventory]","Form.[ItemNo]=[ItemNo]")
This doesn't work, probably because it does not reference the Sub Form.
How can I re-write this to make it work?
Tom