• Can’t enter data into form (2000)

    Author
    Topic
    #389454

    Hello all, I have a problem that I’ve been banging my head against for a while this morning, and I thought that I would seek out some advice.

    I have a form that summarizes information about an individual and provides links to various tracking items (other forms) for an individual’s time in a job training program. At the bottom of this form is an area where one of six different subforms can be loaded by pressing command buttons. (these are largely having to do with personal/demographic information.) The db is split front-end/back-end, with a front-end on each workstation. There is user-level security in place.

    The problem arose this morning when one of the staff alerted me that she could not enter data into any of these subforms. I confirmed this, gave her a new copy and the problems persisted. I’m not sure where the problem is arising, but if I bring up any of the subforms by themselves (i.e., not as a subform in another form, but just as a form) I can enter data. I can change data directly in the queries behind the form.

    The last time new information was entered through these was a week ago, but before that they had been working fine.

    I must admit that I’m completely at a loss of what to do next, short of rebuilding the entire form from scratch (which I would like to avoid because it’s rather large) does anyone have any ideas?

    thanks,
    -Karl

    Viewing 0 reply threads
    Author
    Replies
    • #687833

      You say that the subforms can be loaded into the main form by pressing a command button. What code do you use for this?

      • #687836

        Here’s what is behind each of the buttons:

        Me!PersonSubForm.SourceObject = “subfrmPersonal” [or the name of the subform]
        Me!PersonSubForm.LinkChildFields = “PersonID”
        Me!PersonSubForm.LinkMasterFields = “PersonID”

        • #687837

          okay, I feel really silly; I had the locked property on the subform control set to “Yes”. No idea why I’d done that, but it’s fixed…

          thanks for starting to help me Hans.
          -Karl

          • #687839

            Sometimes you overlook the obvious – things like this have happened to me too! grin

    Viewing 0 reply threads
    Reply To: Can’t enter data into form (2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: