referencing fields

[Onslaughtdave]

Hello,

How do you reference a table and field in a form using vba?

i got a [Form]![whatever]![field] working but how do i do one that isnt in a form, but is just a table...


thanks

 

[PHV]

field in a form
Forms have Controls, no Fields.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Onslaughtdave]

ok,

so what would i use to get a value out of a table?

 

[PHV]

Take a look at the DLookUp function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Onslaughtdave]

That would work, however:

how do i get it to look up more then 1 value...

I do one Dlookup, but the return into a variable but when it hits the second dloopup to get another value in another field, i get an error saying that i canceled the previous operation.

thanks PHV your a big help to a newbie

 

[Onslaughtdave]

That would work, however:

how do i get it to look up more then 1 value...

I do one Dlookup, put the return into a variable but when it hits the second dlookup to get another value in another field, i get an error saying that i canceled the previous operation.

thanks PHV your a big help to a newbie

 

[Onslaughtdave]

srry bout the multi post, said it failed...guess it didnt...