none
Why is my form prompting me for a parameter value? RRS feed

  • Question

  • On my form I renamed a textbox from ClientName to txtClientName so I could unambiguously reference it in some VBA code. ClientName, itself, is a column in the table the form is based on.

    Since I changed the name, the form is now prompting me for the value of the txtClientName parameter when I open it.  If I hit cancel, the form doesn't open.  If I hit okay, leaving the prompt blank, the form opens to what I'm guessing is the first record in the table, ignoring my sort settings.

    The code I added to the form seems to be working properly once I get in and select a valid client.  And if I comment out all the code, leaving an empty event handler, I still get prompted, so it's not in the code.

    How can I determine why the form thinks there is a txtClientName parameter?

    Thanks.

    J


    http://digitalcamel.blogspot.com/

    Monday, June 13, 2016 7:23 PM

Answers

  • Hi J. Couple of places to check: Record Source, OrderBy, and Filter. Hope it helps...
    • Marked as answer by Digital Camel Thursday, June 16, 2016 6:36 PM
    Monday, June 13, 2016 7:28 PM
  • I'll bet you have the Name tracking Auto-correct turned on. That will change field names in very peculiar ways. Go to File tab>Options> Current Database and turn it off. Then do the search that DBguy suggested. Most likely it is in your form's query.

    If you still can't find it get the freeware V-Tools from skrol29.com. Use the add-in for Deep Search. It will run a find on everything in the database.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by Digital Camel Thursday, June 16, 2016 6:36 PM
    Monday, June 13, 2016 8:34 PM

All replies

  • Hi J. Couple of places to check: Record Source, OrderBy, and Filter. Hope it helps...
    • Marked as answer by Digital Camel Thursday, June 16, 2016 6:36 PM
    Monday, June 13, 2016 7:28 PM
  • I'll bet you have the Name tracking Auto-correct turned on. That will change field names in very peculiar ways. Go to File tab>Options> Current Database and turn it off. Then do the search that DBguy suggested. Most likely it is in your form's query.

    If you still can't find it get the freeware V-Tools from skrol29.com. Use the add-in for Deep Search. It will run a find on everything in the database.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    • Marked as answer by Digital Camel Thursday, June 16, 2016 6:36 PM
    Monday, June 13, 2016 8:34 PM
  • Hi Digital Camel,

    please check the suggestion given by the .theDBguy and Bill Mosca, MVP

    I think the suggestion given by him can solve your issue.

    if you think it can solved your issue then I would recommend you to mark the suggestion given by him as an Answer.

    if you still having a problem regarding that please let us know so that we can provide you further help.

    Regards

    Deepak


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, June 14, 2016 4:40 AM
    Moderator
  • 'Twas in the OrderBy property.  Not sure why they correlate a change to the name of a control to a field that can be sorted on...  I would understand auto-updating if the data source had changed, but the control name?  Seems a bit over zealous on the part of name tracking.

    Thanks.

    J


    http://digitalcamel.blogspot.com/

    Thursday, June 16, 2016 6:36 PM
  • Hi J. Glad to hear you got it sorted out. We're all happy to assist. Good luck with your project.
    Thursday, June 16, 2016 6:43 PM
  • 'Twas in the OrderBy property.  Not sure why they correlate a change to the name of a control to a field that can be sorted on...  I would understand auto-updating if the data source had changed, but the control name?  Seems a bit over zealous on the part of name tracking.

    Thanks.

    J


    http://digitalcamel.blogspot.com/

    The first thing I do with a new database is to turn off the Name tracking. It bites me every time. Another thing that is tricky is using the description column for the filed name in a query. I don't know how many times I've searched for a field named "Customer ID" only to find out the REAL name was CustID.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Thursday, June 16, 2016 7:55 PM