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
|
|||
|
|||
Lookup / Paste Data Functionality
In Filemakerpro there is the ability to lookup and PASTE a value into a
field? For instance, in an order entry system it would be nice to paste the current price of a product into the order. Since prices can change a simple lookup will not work. So is there a way to do this? Any assistance will be most appreciated. |
#2
|
|||
|
|||
Lookup / Paste Data Functionality
Use DLookup() in the AfterUpdate event procedure of the combo box where you
choose the product to look up the current price in the product table and assign it to the price in the current form. For an example, open the Northwind database, the order details subform, and see the code attached to the AfterUpdate event procedure of the ProductID combo. -- 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. "Richard Kayton" wrote in message ... In Filemakerpro there is the ability to lookup and PASTE a value into a field? For instance, in an order entry system it would be nice to paste the current price of a product into the order. Since prices can change a simple lookup will not work. So is there a way to do this? Any assistance will be most appreciated. |
Thread Tools | |
Display Modes | |
|
|