Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Form/subform problem (2003)

    I have a form and subform, whos tables are linked by ID. On the main form, I have a control called Log No. I created a record with a log number of 2a. When I created a new record, I type in 2, and the details from the previous record appeared in the subform, until I tabbed down to the subform, then everything was ok. How can I prevent this?

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

    Re: Form/subform problem (2003)

    I don't think I can help without seeing (a stripped down copy of) the database.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Form/subform problem (2003)

    I've stripped it down, and converted it to '97 format, but got a message saying I had missing reference for '97.
    Attached Files Attached Files

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

    Re: Form/subform problem (2003)

    The reference wasn't a problem since I had to convert back to Access 2000 format again.

    I don't know what causes the problem, but you can get around it by placing a text box bound to the ID field on the main form; you can set its Visible property to No to hide it. Apparently having a text box bound to the link field prevents confusion on the subform.

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Form/subform problem (2003)

    Thanks Hans. That's done the trick.

Posting Permissions

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