what if

[Guest]

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

 

[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

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.

 

[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

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

John W. Vinson[MVP]

 

[Guest]

thank you. this helped.

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

John W. Vinson[MVP]