If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
DLookup()
I posted something regarding lookup values(22/11/2004).A solution was
suggested which requires me to use the DLookup() which I have read and understood, but the probem is, where exactly do I type these DLookup commands, is it on the field just next to the After Update,or in the expression builder? Please help, wantula |
#2
|
|||
|
|||
Actually based on your earlier posting, your combo box can contain the
column with the unit price. If your combo box name is cboItem and its row source is SELECT Item, UnitPrice FROM Stock Assuming you want to "display" the UnitPrice in a text box, use a Control Source of a text box of =cboItem.Column(1) BTW: please keep all questions in the same thread rather than requiring us to search for your previous posts. -- Duane Hookom MS Access MVP -- "Wantula" wrote in message ... I posted something regarding lookup values(22/11/2004).A solution was suggested which requires me to use the DLookup() which I have read and understood, but the probem is, where exactly do I type these DLookup commands, is it on the field just next to the After Update,or in the expression builder? Please help, wantula |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DLookUp for multiple forms | [email protected] | Using Forms | 4 | January 9th, 2005 10:48 AM |
Dlookup | Peter | Running & Setting Up Queries | 2 | August 5th, 2004 08:39 AM |
DLOOKUP in an external Database gives TYPE Mismatch-Error | Reiner Harmgardt | General Discussion | 1 | July 22nd, 2004 09:00 AM |
DLookup | Jennifer | Using Forms | 0 | June 18th, 2004 07:16 AM |
DLookup Function in Queries | Jim | Running & Setting Up Queries | 1 | June 10th, 2004 07:07 PM |