Opening a new linked form gives #Name error (1 Viewer)

Lanser · May 21, 2019

I have a main form with a reference number(DocRef) NOT the record ID

I set a command button to open a new form to add to a table linked to the main table but I can't get the Reference to come across I just get a #Name? error and unless I manually enter the DocRef it just creates a blank entry I have tried using a Where statement instead of OpenArgs but that just leaves the reference box blank

On Documents Form

Code:

Private Sub New_Version_Click()
DoCmd.OpenForm "NewVerForm", DataMode:=acFormAdd, WindowMode:=acDialog, OpenArgs:=Me.DocRef
End Sub

and New Version Form

Code:

Private Sub Form_Open(Cancel As Integer)
Me.DocRef.DefaultValue = Me.OpenArgs
End Sub

missinglinq · May 21, 2019

In the secondary Form, try moving your code to the Form_Load event, instead of the Form_Open event. Generally speaking...Form_Open is to early to try doing any type of data manipulation.

Linq ;0)>

Lanser · May 22, 2019

Moving the code to on Load made no difference.

With a bit of playing using MsgBox it appears that a Null value is being passed to the new form even though the correct DocRef value is found

Using MsgBox in the on load gives an invalid use of null and on the Click OpenArgs tooltip is Null but Me.DocRef is showing correct value

Sorry again added the wrong test db

theDBguy · May 22, 2019

Lanser said:
Moving the code to on Load made no difference.

With a bit of playing using MsgBox it appears that a Null value is being passed to the new form even though the correct DocRef value is found

Using MsgBox in the on load gives an invalid use of null and on the Click OpenArgs tooltip is Null but Me.DocRef is showing correct value

Hi. It's kind of hard to test your db without the data file. Which form are we supposed to check?

Lanser · May 23, 2019

Opps sorry its on the Main Document Form (DocForm) on the switchboard, and the New Version form (NewVerForm) is triggered by the New Version button as the image in my first post

Gasman · May 23, 2019

Need the BE as well?

Lanser · May 23, 2019

Updated post with correct db

gemma-the-husky · May 23, 2019

does this work?

Me.DocRef.DefaultValue = Me.OpenArgs

perhaps it needs to be in the current event.

Code:

if me.newrecord then 
    Me.DocRef.DefaultValue = Me.OpenArgs
end if

note that openargs is a string,

-----
[edit]

also, maybe the call should be ! not .

OpenArgs:=Me!DocRef

Lanser · May 23, 2019

Thanks for the quick response, but no that makes no difference

Gasman · May 23, 2019

Well I initially had Null as well, but now I get the value,no idea why. I did change the call to just positional parameters, but now back to your keyword version, but still #Name on form.?

Msgbox on form open

Gasman · May 23, 2019

I have a workaround, providing you can get the value into the form as OpenArgs.

Put this code in the Load event

Code:

Me.DocRef = Me.OpenArgs

HTH

Lanser · May 23, 2019

Well that works so far, as simple as taking out the .DefaultValue its finally getting near useable for me anyways

Thanks a lot for your help

Gasman · May 23, 2019

If you think about it, you do not need a default value as it is likely to change all the time.?

Micron · May 23, 2019

The solution is hidden in post 8 comment. Maybe if open args was passed to a string variable first, then use the variable; otherwise
"'" & Me.OpenArgs & "'"

EDIT -
No to variable - must wrap in quotes.

Gasman · May 23, 2019

Micron said:
The solution is hidden in post 8 comment. Maybe if open args was passed to a string variable first, then use the variable; otherwise
"'" & Me.OpenArgs & "'"

Micron,
Why does it work for Me.DocRef then.?
Still not sure why I was receiving Null when I first downloaded the DB

Micron · May 23, 2019

Gasman said:
Micron,
Why does it work for Me.DocRef then.?

Not sure but my guess would be that the DefaultValue property data type is Variant seeing as how it can accept anything but auto number or OLE. Therefore, the OpenArgs value would have to be properly delimited to comply with the data type of the bound field because you're passing a variant to it. A text field is already defined as text data type, thus would accept OpenArgs being passed to its Value property (which is the default property for a textbox) as long as OpenArgs could be interpreted as text.

That's all just speculation on my part. I can find no info on the data type of the DefaultValue property.

theDBguy · May 23, 2019

Micron said:
I can find no info on the data type of the DefaultValue property.

Here's what the Help File says on the topic.

Gasman · May 23, 2019

Nice one theDBguy,

The following works. However I'd still go with my method, just for a little less typing, but good to know about.

Code:

Private Sub Form_Open(Cancel As Integer)
Me.DocRef.DefaultValue = """ & Me.OpenArgs & """
MsgBox Me.OpenArgs

End Sub

Micron · May 23, 2019

Gasman said:
However I'd still go with my method...

Code:

Me.DocRef.DefaultValue = """ & Me.OpenArgs & """

Is that what you had? Upon reviewing your posts I can't find where you were using that otherwise I wouldn't have suggested it at such a late stage. Thanks dbg - it's there in web docs as well. I missed it.

So the explanation is that OpenArgs of text type have to be delimited same as if you were trying to pass a literal string to a control, such as "apple"?

Gasman · May 23, 2019

Lanser said:
Well that works so far, as simple as taking out the .DefaultValue its finally getting near useable for me anyways

Thanks a lot for your help

Just realised that is you wanted to add more than one record at a time, you would need defaultvalue?

Opening a new linked form gives #Name error (1 Viewer)

Registered User.

Attachments

AWF VIP

Registered User.

Attachments

I’m here to help

Registered User.

Enthusiastic Amateur

Registered User.

Super Moderator

Registered User.

Enthusiastic Amateur

Attachments

Enthusiastic Amateur

Registered User.

Enthusiastic Amateur

AWF VIP

Enthusiastic Amateur

AWF VIP

I’m here to help

Attachments

Enthusiastic Amateur

AWF VIP

Enthusiastic Amateur

Similar threads

Users who are viewing this thread