Gasman
Enthusiastic Amateur
- Local time
- Today, 17:54
- Joined
- Sep 21, 2011
- Messages
- 14,259
Not me Micron, Lanser was the o/p.
I was just trying to get to the bottom of the problem.
Lanser was just assigning OpenArgs on it's own.
Opening a new linked form gives #Name error (1 Viewer)
- Thread starter Lanser
- Start date
Not me Micron, Lanser was the o/p.
I was just trying to get to the bottom of the problem.
Lanser was just assigning OpenArgs on it's own.
- Local time
- Today, 09:54
- Joined
- Oct 29, 2018
- Messages
- 21,467
And the other thing is if the users change their minds and simply closed the new form, you could get left with an empty record if you didn't use the default value property.
Last edited:
@Gasman; I realize you weren't OP but I read
However I'd still go with my method, just for a little less typing, but good to know about.
Me.DocRef.DefaultValue = """ & Me.OpenArgs & """
as if it was your method. Not sure what your method is - perhaps just assigning to the vale property then. dbg makes a good point about possible incomplete record.
However I'd still go with my method, just for a little less typing, but good to know about.
Me.DocRef.DefaultValue = """ & Me.OpenArgs & """
as if it was your method. Not sure what your method is - perhaps just assigning to the vale property then. dbg makes a good point about possible incomplete record.
Last edited:
Gasman
Enthusiastic Amateur
- Local time
- Today, 17:54
- Joined
- Sep 21, 2011
- Messages
- 14,259
My method was just to set the control value to the OpenArgs, not it's DefaultValue, however I have since realised that in some circumstances that would not be the best way.
That is how I have done it in the past, with Esc to cancel a new record.
That is how I have done it in the past, with Esc to cancel a new record.
missinglinq
AWF VIP
- Local time
- Today, 12:54
- Joined
- Jun 20, 2003
- Messages
- 6,423
Knew something didn't look quit right...actually that has to be
Me.DocRef.DefaultValue = """" & Me.OpenArgs & """"
or else the Default Value you'll end up with will be
& Me.OpenArgs &
not the passed value.
Linq ;0)>
Me.DocRef.DefaultValue = """" & Me.OpenArgs & """"
or else the Default Value you'll end up with will be
& Me.OpenArgs &
not the passed value.
Linq ;0)>
Hmmm - don't know why. What I posted worked for me
"'" & Me.OpenArgs & "'"
missinglinq
AWF VIP
- Local time
- Today, 12:54
- Joined
- Jun 20, 2003
- Messages
- 6,423
Surprisinghly...what you just posted
"""" & Me.OpenArgs & """"
but the original code, which was co-opted from Access Help, was
" " " & Me.OpenArgs & " " "
with three Double Quotes on each end...which doesn't work, as I noted...instead of Double Quote - Single Quote - Double Quote, which does.
Is anyone surprised that Access Help got it wrong?
Linq ;0)>
does, indeed, work! As well as my code
"""" & Me.OpenArgs & """"
but the original code, which was co-opted from Access Help, was
" " " & Me.OpenArgs & " " "
with three Double Quotes on each end...which doesn't work, as I noted...instead of Double Quote - Single Quote - Double Quote, which does.
Is anyone surprised that Access Help got it wrong?
Linq ;0)>
missinglinq
AWF VIP
- Local time
- Today, 12:54
- Joined
- Jun 20, 2003
- Messages
- 6,423
Running the code in your posted file...using
""" & Me.OpenArgs & """
with 3 Double Quotes, on either end
produces
& Me.OpenArgs &
in the Control, as I said...not the appropriate DocRef.
Linq ;0)>
Gasman
Enthusiastic Amateur
- Local time
- Today, 17:54
- Joined
- Sep 21, 2011
- Messages
- 14,259
My apologies,
I had created a new form in case the form was corrupted and was still using that, with my original Load method. :banghead::banghead:
I had created a new form in case the form was corrupted and was still using that, with my original Load method. :banghead::banghead:
Similar threads
