Solved

stLinkCriteria

Posted on 2004-08-18
14
4,982 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
  • 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
 

Author Comment

by:JordanKingsley
ID: 11833810
thanks M
0
 
LVL 50

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 50

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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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 50

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 50

Expert Comment

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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

895 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now