How to use data from a table, in a VBA program

[halx]

Hello !

I have a problem with VBA for Access.

Suppose you have a table "tblEmployees" that has two fields: "Name" and "Position".

Does anybody know how to get the position of the employee called "smith" and put it in the VBA variable defined as:
Dim pos As String ?
(the problem is not with SQL, but with storing the answer of the query)

Thanks

Alx

 

[jebry]

Hi alx!

Try this:

pos = DLookUp("Position", "tblEmployees", "Name = 'smith'&quot

hth
Jeff Bridgham
bridgham@purdue.edu

 

[halx]

Thanks !

This is really a great forum, I have found a lot of tips for VBA for Access.
I hope I will be able to contribute usefuly, one day.

Bye !

Alex