Dlookup for finf stock Position

=DLookup("current_stock", "tblStock", "[Stock_Id] = 1") it works for Stock-ID=1 in the main form
arnelgp said:
=DLookup("current_stock", "tblStock", "Stock_Id = & CLng("0" & Replace([Forms]![SK Enterprice]![TblInvoiceDetail Subform].[Form]![ITEMID] , "P", ""))
Click to expand...
getting compie error in "0"
 
You must log in or register to reply here.

Similar threads

A
Secure Storage Model for Microsoft Access: Stream-Based Encrypted Data Architecture(for discussion)
Replies
5
Views
386
GPGeorge
GPGeorge
M
Populate Sub Form with similar to last main form record data
Replies
6
Views
1,389
MHART08
M
D
  • Locked
Randomizing Data for Posted db's
Replies
9
Views
4,566
MajP
MajP
W
Dlookup Issues
Replies
4
Views
456
Minty
Minty
E
Use Dlookup to enter data, and How to use subform of linking table for similar tbl
Replies
2
Views
1,124
Essel30
E

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom