D LookUp

[Kim]

How does D lookUp work on a form??

Give an example based on this:


copy of qry:CANTEST:Form(name of Form)

fields

FY
NEW CAN#
TOTAL AMOUNT

tbl:FYCAN2003(name of Table)

Boxes

CAN
RESEARCH
DIVISION
POOL
Notes

I want the form to go to the table if both CAN's equal
the add the other 4 columns to the form.

 

[Guest]

Check the Help files for the specifics on DLookUps and syntax
For the comparison, I would try

Dim strCan1 As Strin
Dim strCan2 As Strin

strCan1 = DLookUp( ..
strCan2 = DLookUp( ..

If strCan1 = strCan2 Then ..


----- Kim wrote: ----

How does D lookUp work on a form?

Give an example based on this


copy of qry:CANTEST:Form(name of Form

field

F
NEW CAN
TOTAL AMOUN

tbl:FYCAN2003(name of Table

Boxe

CA
RESEARC
DIVISIO
POOL
Note

I want the form to go to the table if both CAN's equa
the add the other 4 columns to the form