Enter Parameter value (1 Viewer)

libin04

New member
Local time
Today, 08:41
Joined
Aug 10, 2022
Messages
14
Hello everyone.

I am getting this error when i trying you open the form. Can anyone out there help me? Let me know if you need more info to diagnose.
1667652680060.png
 

Attachments

  • 1667651458315.png
    1667651458315.png
    2.7 KB · Views: 46

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:41
Joined
May 7, 2009
Messages
19,246
firstly, you add square bracket [] to your form name since
it has "slash" on the formname. access might mistaken it
as you are doing division operation.

[Forms]![NavitionFormTL/SPR]![NavigationSubform].[Form]!whidtxt

if the subform where whidtxt belongs is not currently in Focus, there
is no guarantee that the above will work.
 

libin04

New member
Local time
Today, 08:41
Joined
Aug 10, 2022
Messages
14
I follow the same in my query. but still it showing the error
1667653504735.png
 

Gasman

Enthusiastic Amateur
Local time
Today, 08:41
Joined
Sep 21, 2011
Messages
14,448
Perhaps use the Builder as Access cannot find that parameter?
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 03:41
Joined
May 21, 2018
Messages
8,605
I assume that is a subform or subreport
Code:
forms![navigationFormTLS/SPR]![productivityReport].Form![whidtxt]
forms![navigationFormTLS/SPR]![productivityReport].report![whidtxt]
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:41
Joined
May 7, 2009
Messages
19,246
if you did not Rename your subform, then it will be called NavigationSubForm, see post #2.
 

Users who are viewing this thread

Top Bottom