Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can't enter data into form (2000)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't enter data into form (2000)

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

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't enter data into form (2000)

    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"

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    New York, New York
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can't enter data into form (2000)

    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

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Can't enter data into form (2000)

    Sometimes you overlook the obvious - things like this have happened to me too! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •