Results 1 to 7 of 7
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Locked Record? (2002 SP-2)

    I have frmParticipants (tblMaster) and have just created frmInboundSurvey (qryInboundSurvey).
    qryInboundSurvey is based on tblMaster and tblInboundSurvey with one to many relationships for txtLastName and txtFirstName. frmParticipants has a cmdbtn that calls frmInboundSurvey (linked by txtID). The form comes up with all the correct entries from tblMaster (which I have locked), but I can
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

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

    Re: Locked Record? (2002 SP-2)

    We'd need to see the form.

  3. #3
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Locked Record? (2002 SP-2)

    Uh. . .you mean an actual image of the form?
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

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

    Re: Locked Record? (2002 SP-2)

    No, a stripped down copy of the database.

  5. #5
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Locked Record? (2002 SP-2)

    Stripped db too large to attach. . standby.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  6. #6
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Locked Record? (2002 SP-2)

    <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> . . .what a dummy!
    All I needed to do was include the survey questions in tblMaster. I was making a mountain out of a mole hill! No need for the second table or query.
    Thanks for listening to me make an idiot out of myself.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

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

    Re: Locked Record? (2002 SP-2)

    Well, glad you found it yourself! Phew!

Posting Permissions

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