Subform asking for Parameter Value

Posted on 2004-11-24
Last Modified: 2011-10-03
access 2000
win 2000 sp4

I have a checkbox that I'am using to try and change the master and child  link fields.
But I keep getting a Box asking for a parameter value.

' code ---------------------------------------------------------------
Private Sub Check3_Click()
       Forms!frmSearch![data1 SUBFORM].SourceObject = "Data1 Subform"
        Forms!frmSearch![data1 SUBFORM].LinkMasterFields = [Text13]
        Forms!frmSearch![data1 SUBFORM].LinkChildFields = [MFRNUM]

Any suggestions?
Question by:fordraiders
    LVL 77

    Accepted Solution

    Hello fordraiders,

    I've never done this but I would assume that the values you assign must be strings.
    So my first guess would be:

    Forms!frmSearch![data1 SUBFORM].SourceObject = "Data1 Subform"
    Forms!frmSearch![data1 SUBFORM].LinkMasterFields = "[Text13]"
    Forms!frmSearch![data1 SUBFORM].LinkChildFields = "[MFRNUM]"

    LVL 3

    Author Comment

    ah !!!
    Correct, basic stuff....
    Appreciate the awakening....

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    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…

    734 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

    23 Experts available now in Live!

    Get 1:1 Help Now