DLOOKUP FUNCTION

[Guest]

I am trying to tranfer data from a quote file to an order file upon receipt of an order
This is the formula I have now

=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOTE NUMBER]=

![SIGNATURE QUOTE NUMBER]"

I want to lookup the SIGNATURE DWG # A in my quote file when SIGNAUTRE QUOTE NUMBER in my orders form is the same as SIGNATURE QUOTE NUMBER in my quote file. The formula above works for the first quote but when i have a new order with another quote number it returns the value for the first quote in the quote form. When I enter quote 2 in my order form i need it to return the SIGNATURE DWG # A for quote 2.

I anyone has any suggestions it would be greatly appreciated. Thanks Shawn

 

[Gerald Stanley]

Try
=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOTE
NUMBER]= " &

![SIGNATURE QUOTE NUMBER])

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
I am trying to tranfer data from a quote file to an order file upon receipt of an order.
This is the formula I have now.

=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOTE NUMBER]=![SIGNATURE QUOTE NUMBER]")

I want to lookup the SIGNATURE DWG # A in my quote file

when SIGNAUTRE QUOTE NUMBER in my orders form is the same
as SIGNATURE QUOTE NUMBER in my quote file. The formula
above works for the first quote but when i have a new order
with another quote number it returns the value for the
first quote in the quote form. When I enter quote 2 in my
order form i need it to return the SIGNATURE DWG # A for
quote 2.

 

[Guest]

I tried using this suggestions but i get an error #NAME?
I am having a hard time with this one so if there are any more suggestions it would help me out alo
thank in advance
Shaw

----- Gerald Stanley wrote: ----

Tr
=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOT
NUMBER]= " &

![SIGNATURE QUOTE NUMBER]

Hope This Help
Gerald Stanley MCS

-----Original Message----
I am trying to tranfer data from a quote file to an orde file upon receipt of an order
This is the formula I have now

=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOT NUMBER]=

![SIGNATURE QUOTE NUMBER]"
I want to lookup the SIGNATURE DWG # A in my quote fil

when SIGNAUTRE QUOTE NUMBER in my orders form is the sam
as SIGNATURE QUOTE NUMBER in my quote file. The formul
above works for the first quote but when i have a new orde
with another quote number it returns the value for th
first quote in the quote form. When I enter quote 2 in m
order form i need it to return the SIGNATURE DWG # A fo
quote 2.

 

[Gerald Stanley]

Try
=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOTE
NUMBER]= " & Forms!

![SIGNATURE QUOTE NUMBER])

If this formula is on the Quote form, try
=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOTE
NUMBER]= " & [SIGNATURE QUOTE NUMBER])

Hope This Helps
Gerald Staney MCSD

-----Original Message-----
I tried using this suggestions but i get an error #NAME?.
I am having a hard time with this one so if there are any

more suggestions it would help me out alot

thank in advance.
Shawn

----- Gerald Stanley wrote: -----

Try
=DLookUp("[SIGNATURE DWG # A]","

","[SIGNATURE QUOTE
NUMBER]= " &

![SIGNATURE QUOTE NUMBER])

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
I am trying to tranfer data from a quote file to an

order
file upon receipt of an order.

This is the formula I have now.

=DLookUp("[SIGNATURE DWG #

A]","","[SIGNATURE QUOTE

NUMBER]=

![SIGNATURE QUOTE NUMBER]")when SIGNAUTRE QUOTE NUMBER in my orders form is the same
as SIGNATURE QUOTE NUMBER in my quote file. The formula
above works for the first quote but when i have a new order
with another quote number it returns the value for the
first quote in the quote form. When I enter quote 2 in my
order form i need it to return the SIGNATURE DWG # A for
quote 2.

appreciated. Thanks Shawn
.

.