OpenArgs - Passing a Prefixed Auto Number

[Steven19]

Hello



I am doing a simple DoCmd, OpenArgs.

DoCmd. OpenForm "FrmNewDocument",,,"BCPKey = " & Me.[BCPKey],,, Me.BCPKey

with the following OpenArgs

If Me.OpenArgs <> "" Then
Me.[BCPKey].DefaultValue = "" & Me.OpenArgs & ""
End IF

However the BCPKey is a Primary Key with a a format of "BCP"0

Now, viewing this information in my datasheet I have the the prefix, but how do I add the prefix to the new form being opened?

Regards

[Minty]

Have you checked to see what is actually being passed to the form in the open args?

I would simply format it the same ("BCP"0) in the New Document form?
You want it to be the same actual underlying data, so just ensure it is handled in the same way.