Best function to extract a value (The word reference) from a string 1

[Pack10]

I need to develop a function that will read a string of characters that has the value "Reference 9999" embedded somewhere in it. What is the best function to do this.
Thx

 

[PHV]

Have a look at the InStr function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pack10]

Yep, thats the one. Thanks

 

[Pack10]

From parsing out this string I get a number which I wanted to use in a DLOOKUP. However, I get error 2471. In the debugger if I hardcode a value the DLookup works fine, however I get the 2471 error when I use the value in the variable as part of the dlookup. How can I get around this?

 

[mintjulep]

Type error maybe? If you parse a "number" out of a string you still have a string.

 

[PHV]

Why not post the code raising the error ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pack10]

Here's the code
The value in holdparent is something like 122, or 118...

holdParent = Mid$(objMessage, intPos + 9, 5)

strAssignedTo = DLookup"[Assigned_To]", "[Assigned_DDQs]", "[Parent] = holdParent")

 

[Pack10]

I actually scrapped this for a findfirst on the recordset and it worked fine. But I really dont understand why the parameter value (mem variable) I was using does not work with DLOOKUP.

 

[strongm]

It is because

>strAssignedTo = DLookup"[Assigned_To]", "[Assigned_DDQs]", "[Parent] = holdParent")

is wrong. Try

DLookup"[Assigned_To]", "[Assigned_DDQs]", "[Parent] = " & holdParent)

 

[Pack10]

I will try it but I believe I did try that. Anyway I
Used a findfirst which worked.