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

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?

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

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?

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.

Also , refer to this article;

http://support.microsoft.com/kb/285866