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
|
|||
|
|||
Linking Unit Price
I have an order entry database that I created. When
entering an order I need the unit price of the item to bring up a default value from the products table AND I need to be able to change the unit price for that specific order and store it in the orders table (without changing the products table). In the sample databases that I have looked at it works this way, however I can not get it to work in mine. I do not know what I am missing. it has to be something in relationships or tables. Any ideas?! |
#2
|
|||
|
|||
Linking Unit Price
1. Open the Northwind sample database.
2. Open the Orders Subform in design view. 3. Right-click the ProductID combo box, and choose Properties. 4. On the Event tab, choose After Update, and click the Build button (...). Access opens the code window. You can see how they build a filter string, and then use DLookup() to read the UnitPrice field from the Products table. For more help on DLookup(), see: Getting a value from a table: DLookup() at: http://allenbrowne.com/casu-07.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Joe" wrote in message ... I have an order entry database that I created. When entering an order I need the unit price of the item to bring up a default value from the products table AND I need to be able to change the unit price for that specific order and store it in the orders table (without changing the products table). In the sample databases that I have looked at it works this way, however I can not get it to work in mine. I do not know what I am missing. it has to be something in relationships or tables. Any ideas?! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keeping Records in Linking Table Accurate (Long Post) | Ben Johnson | Running & Setting Up Queries | 0 | June 14th, 2004 08:13 AM |
sorting by price and calculating totals excluding hidden rows | Karen Burleigh | Worksheet Functions | 2 | April 21st, 2004 09:40 PM |
Change price if cost increases x amount? | Pam | Worksheet Functions | 1 | February 20th, 2004 10:47 PM |
Stacked Charts with price on 2nd axis | Tushar Mehta | Charts and Charting | 1 | December 19th, 2003 01:52 PM |