dlookup question

[lula]

hi to all.... I'm new in programming and I have a question....

I need to bring the urgency id from the urgency word. I have a table named:
urgency where I have id_urgency and desc_urgency.

I have a word doc where I look for the urgency name and I need to have in my
DB the id, not the word:

ie: in my word doc I have
Urgency: average

in my urgency table, I have:
id: 1 --- desc: average
id:2 ---- desc: low

I need to get the id = 1 in my DB...

I have this code

Dim lngUrgency As Long

strUrgency = oDoc.FormFields("Dropdown5").Result
lngUrgency = DLookup("[id_urgency]", "Urgency", "[desc_urgency]" =
strUrgency)

between other things.. but when I run it, lngUrgency brings me NULL.... does
someone know what am I doing wrong????

thank you in advance....

 

[lula]

thank you... I think that was it!!! thank you a lot for your help ofer!

Hi,
You need to change the DlookUp, move the closing quote to the end of the
equall sign
lngUrgency = DLookup("[id_urgency]", "Urgency", "[desc_urgency] = " &
strUrgency)

Now, if strUrgency is string type, it should be
lngUrgency = DLookup("[id_urgency]", "Urgency", "[desc_urgency] = '" &
strUrgency & "'")

--
I hope that helped
Good Luck

hi to all.... I'm new in programming and I have a question....

I need to bring the urgency id from the urgency word. I have a table named:
urgency where I have id_urgency and desc_urgency.

I have a word doc where I look for the urgency name and I need to have in my
DB the id, not the word:

ie: in my word doc I have
Urgency: average

in my urgency table, I have:
id: 1 --- desc: average
id:2 ---- desc: low

I need to get the id = 1 in my DB...

I have this code

Dim lngUrgency As Long

strUrgency = oDoc.FormFields("Dropdown5").Result
lngUrgency = DLookup("[id_urgency]", "Urgency", "[desc_urgency]" =
strUrgency)

between other things.. but when I run it, lngUrgency brings me NULL.... does
someone know what am I doing wrong????

thank you in advance....