Using Replace function with pipes, vba

[mjdemaris]

So I got this code from Northwind and it seemed to work fine until today, as I've been making some changes.

=Replace("Request#|","|",Nz([RequestID],"(New"))

What it is supposed to do (if I understand this right) is look up the RequestID from a table and display it, otherwise display (New).

It was working, but now it displays the next RequestID - which does not even exist! So, I am wondering what the pipes do and if this is actually looking up the ID correctly.

Thanks,
Mike

 

[Ranman256]

Run an update query,and use the replace function in the field.

 

[mjdemaris]

Sorry Ranman, but I don't follow.

BTW, this code is in the Control Source property of a text box, used as a Header for a form.

 

[static]

That code is just replacing one string with another (requestID). It's not 'looking up' anything.

 

[mjdemaris]

So, what do the pipes do?

 

[static]

Nothing. It's just a placeholder character that gets replaced by the new string.

 

[mjdemaris]

Ok. How do you think it could return a value (unique ID, autonumber, from table: Request) that does not even exist?

Unless...somehow that value is created on the form somewhere...hmmm.

 

[mjdemaris]

Yep, it's the form's fault. lol

Thanks guys!