Retrieve a value from table

[Kabous07]

Ciao Ciao

I am struggling to do something simple, but it seems not it does not want to work. I have two tables, one for invoice and one for values. Both of them has the same referance, the Purchase order number(POA). I do not want to type my values over and over for each table, i only want to type the values in the value table and then it must automatically update in the field(using the POA number). I tried using the below. Can you please help, thank you allot!

=DLookUp([Unit list]![POA];[Unit list];[Aermec order]), but i get the #name? error

Unit list is the one with the values
Aermec orders is the field where the reference/lookup will be, the POA number

 

[arnelgp]

what are your form name and field names on each form?

 

[Kabous07]

The forms are:
*Capture orders
**Subform under Capture order is: Unit list
*Capture invoicing
The tables are:
*Orders
*Unit List
*Invoicing

The POA reference number is inserted into the Capture order form into the field Aermec O/N. Then all the values are inserted in the unit list subform. The POA number is then inserted in the Capture invoicing area, then by default the Invoicing field, Quoted Euros, must show the total values of the POA number under the table Unit List.

This is very confusing to explain!

 

[arnelgp]

are capture orders and capture invoice two separate forms?

 

[Kabous07]

Thats correct. I have tried attaching a snip.

 

[Kabous07]

I wont mind sending the access file to you. Would you mind?

 

[arnelgp]

well i guess:

=Forms![Captured Orders]![Unit List].Form![POA]

 

[Kabous07]

I guess it would have worked, but i need to incorperate it in a function that searches that field. What does it mean if it shows <<Expr>>

=DLookUp( Forms![*Capture Orders]![Unit list subform].Form![Aermec PO];[Unit list]; «Expr» [Aermec order])

 

[arnelgp]

i am confussed, ok send in the db. guide me as to what you would you like to accomplished

 

[Kabous07]

Thank you allot. I would appreciate it allot. Been trying for more than a month to do this.

You will see there is a few inputs i have plaid around with. But at the Quoted Euros field in the Capture Invoice form i want the total values to be displayed of the specific POA number in the Unit list table. So what will happen is i will capture the unit cost in the unit subform under the capture order form. Once i have inserted the price of the unit, i will go to the invoice form and type in the new POA number in the Aermec order field. Once i have placed the POA number in the Aermec order field i want the price i have put in at Unit list table along with that specific POA number(like POA1) to show in the Quoted Euros field.

 

[arnelgp]

did it got fixed?

 

[Kabous07]

I tried it that way, but it still shows #name?

But do you think that is correct the way i have done it?

 

[arnelgp]

is your order form open? if not open it first before opening the invoice form.

 

[Kabous07]

I tried it quickly, but still does not work. i am currently using:

=DLookUp([Forms]![*Capture Orders]![Unit list subform].[Form]![Aermec PO];[Unit list];[Aermec order])

 

[arnelgp]

no that will not work, dlookup only works for tables and queries, and not on subform.
here try again. make sure that "order" form is open first before opening the invoice form.

 

[Kabous07]

Aaaah you are a genius my friend!!! Well done. Thank you allot this will help me allot, becuase i should be able to apply it to other areas as well.

 

[Kabous07]

Im really impressed. Thanks allot man!