what if

R

rodchar

hey all,

i was wondering what if i had a form and i wanted to see if a record exists
in 2nd or 3rd table would i use DLookUp or is there another way to do this?

thanks,
rodchar
 
F

fredg

hey all,

i was wondering what if i had a form and i wanted to see if a record exists
in 2nd or 3rd table would i use DLookUp or is there another way to do this?

thanks,
rodchar
Click to expand...

Without knowing more, if you just want to see if a record exists,
without returning any value from the record, you could use:

= IIf(DCount("*","TableName","[SomeField] = someCtiteria")>0,"Yes
there is at least one","No it's not")

Look up
DCount as well as Where clause + restrict data to a subset of records
in VBA help to learn how to use this function.
 
J

John Vinson

hey all,

i was wondering what if i had a form and i wanted to see if a record exists
in 2nd or 3rd table would i use DLookUp or is there another way to do this?

thanks,
rodchar
Click to expand...

Yes you could, and yes there is (you could use a Subform to see the
actual records).

John W. Vinson[MVP]
 
Top