Solved

stLinkCriteria

Posted on 2004-08-18
14
5,027 Views
Last Modified: 2011-08-18
Hello all. This one will be simple to you guys but it's driving me totally nuts. I have a Clients Form that has a Command Button to open an Admissions Form. To filter the record being entered into the Admissions Form to be the same UniqueID as the current record in the Client Form I've added "  stLinkCriteria = "[UniqueID]=" & Me![UniqueID]" in the On Click event of the Command Button. The complete code is:

Private Sub Command134_Click()
On Error GoTo Err_Command134_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Admissions"
     stLinkCriteria = "[UniqueID]=" & Me![UniqueID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command134_Click:
    Exit Sub

Err_Command134_Click:
    MsgBox Err.Description
    Resume Exit_Command134_Click
   
End Sub

Simple right? Then in the Default Value property of the UniqueID field on the Admissions Form I've added
"=[Forms]![Clients]![UniqueID]". My problem is that when I click the button to open the Admissions Form I get a message box prompting me to "Enter Parameter Value" and the correct UniqueID is showing. I've done this a hundred times and have never had this stupid message box appear. How do I get rid of this? Thanks, Jordan.
0
Comment
Question by:JordanKingsley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 3
  • +1
14 Comments
 
LVL 5

Expert Comment

by:Emanon_Consulting
ID: 11833411
You should only need the stLinkCriteria to link the forms.

You should be able to delete the "=[Forms]![Clients]![UniqueID]".   I don't think you need this and it may be what is giving you the error.

Cheers
M
0
 

Author Comment

by:JordanKingsley
ID: 11833470
Regardless of if it's there or not I'm getting that prompt. I have 5 other applications set up the exact same way and none of them give the message box.
0
 
LVL 5

Expert Comment

by:Emanon_Consulting
ID: 11833798
I'll ask some others to have a look...

Cheers
M
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:JordanKingsley
ID: 11833810
thanks M
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 11834667
First issue I see is the possibility that Me![UniqueID] is NULL.  Even if it should never be NULL, it's always a good idea to check for it.  Users are notoriously ingenious in finding ways to do things they "can't" do.  :)

' The -1 value is just arbitrary...you can make it whatever you want.
stLinkCriteria = "[UniqueID]=" & NZ(Me![UniqueID],-1)

I also agree with Emanon that you should remove the default value assignment from the [UniqueID] control on the Admissions form.  By setting the link criteria, you are effectively telling the Admissions form that no other [UniqueID] value should be available.

For troubleshooting, I suggest putting a breakpoint in the OnLoad event of the Admissions form, or in the OnClick event for the command button on the main form.  This way you can check the value of stLinkCriteria during execution to verify its validity.  Also, your code assumes that [UniqueID] is a numeric value.  Finally, please detail the title bar and text on the prompt you receive.  It will tell us what parameter it thinks it needs, and may provide a clue as to the source of the error.
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 11834683
DOH!  If you have any code in the OnLoad event of the Admissions form, please post that as well.
0
 

Author Comment

by:JordanKingsley
ID: 11834833
Thanks for looking at this routinet. The UniqueID isn't null. The way this is filtered from Clients to Admissions there shouldn't be any other UniqueID available except the one showing on the Clients Form when the Admissions Form is opened. What you said about the code assuming that the UniqueID is a numeric may be the problem. The UniqueID is a generated field that is a text. It contains first letter of the last name and first letter of the first name. In the past I have used text fields in this manner but they've only contained numbers. An example of a UniqueID is "M04N61225". The exact prompt that I get (if that exact UniqueID was showing is):

 Enter Parameter Value (Blue part of msgbox)

 M04N61225 (Right above text box)

 
 When I click ok it's at that exact UniqueID anyway. You probably have a good idea of what I'm doing wrong now. Thanks
0
 

Author Comment

by:JordanKingsley
ID: 11834838
PS there is no on load event for the Admissions form. The command button is the only source.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 11835035
I'm getting the impression that the error is in another control on the triggered form.
Did you try to open the form "stand alone" and do you get the message box then too ?

When it's a simple form just create a new one and try again, otherwise you'll have to dig into the combo's and other controls that are "data related" by using a query.

Nic;o)
0
 

Author Comment

by:JordanKingsley
ID: 11835109
Hello Nic;0), the message doesn't come up when I open it by it'self. I'll do another form then. I think what routinet said about the code assuming it's a numeric could be the cause.
0
 
LVL 51

Accepted Solution

by:
Steve Bink earned 500 total points
ID: 11835140
stLinkCriteria = "[UniqueID] = '" & Me![UniqueID] & "'"

The only change is the addition of single quotes around Me![UniqueID].  The difference:

Originally:  stLinkCriteria = "[UniqueID] = M04N61225"
After:  stLinkCriteria = "[UniqueID] = 'M04N61225'"

The problem is that Access needs a text string for the parameter.  By not putting the single-quotes around your value, you imply that M04N61225 is a user-provided value to match, and Access in turn asks for it.
0
 

Author Comment

by:JordanKingsley
ID: 11835218
Routinet? You totally RULE !!!! That was exactly it. Thank you so much !!!!!
0
 
LVL 5

Expert Comment

by:Emanon_Consulting
ID: 11835546
Hey Folks

I just got out of my meeting...

>>JordanKingsley - Sorry to have started and then have to leave ya hanging.  Work gets in the way of my free time once in a while!

>> routinet - Thanks a bunch coming to help!

Cheers
Michael
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 11835603
I live to serve.  <smirk>
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question