How can I get a value from a table into a variable

[SashaBuilder3]

Hi everybody,


I know how to get a value from a table through opening a recordset, but I am wondering if there is another way, something like this:

My_var = SELECT column1 from some_table where column2='ABC'

providing that this SELECT returns a single value.


???????

Thanks,

Alexandre

 

[Junior1544]

I'm not able to comment on using a query like that, but here's an idea... check into the dlookup function... that might help you...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.

 

[SashaBuilder3]

James,

Looks like this is what I need.



Thanks a lot!

Alexandre

 

[xqzme]

On 10/15/02 I asked a question about DLookup as I was having problems using this function.

In responding to my question Paul Bricker explained how to use a combo box query for the purpose of populating form controls based upon related tables. You may find this to be useful as well.

 

[SashaBuilder3]

xqzme,


Thanks for the tip, I should definitely have this in my arsenal. As to the DLookup I had no problem to run it.


Alexandre