Paul has attended:
Access Intermediate course
Access Advanced course
Updating Data On A Form Automatically
I have a form for entering sales orders and would like to make, as a default value, the umbrella order number to display from a different table when the part number is entered/selected (haven't decided yet if I want to have a combo box or have the user enter the data)
How would I do this?
Cheers
Paul
RE: Updating Data On A Form Automatically
So you want to add or update your order number when you enter a part number?
what do you mean by umbrella order number?
Is there one main order number, and many part numbers?
RE: Updating Data On A Form Automatically
the form I want to have this on is my main input form.
to one part number, there is one order number
to one order number, there is one part number.
unless there is a special type of order which won't often happen.
As a result, I want to be able to type in the part number on a form and for another field on the same form to display the order number for the entered part - but I want this field to be editable, in case there is this special type of order arising.
so I want:
OrderRef (PK, Autonumber)
Part Number - entered manually or selected from combo box
order number - looked up based on the part number above
qty due
date due
date sent
Thanks in advance
Paul
RE: Updating Data On A Form Automatically
I could do it so easily in Excel!
it would be =vlookup(part number,parttable,3,0)
where the 3rd column along is the order number. Perhaps this may help you see what I'm trying to do?
RE: Updating Data On A Form Automatically
Hi Paul
Try using the DLOOKUP function:
Example:
DLookup("[ContactName]", "[Suppliers]", "[SupplierID] = Forms![SupplierID]")
Displays the value of the ContactName field in the Suppliers table, where the value of the SupplierID field in the table matches the value of the SupplierID control on the active form.
RE: Updating Data On A Form Automatically
Also , refer to this article;
http://support.microsoft.com/kb/285866
