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

    Problem Control (2003)

    I've adapted the attatched database from a previous one, but something seems wrong. I can't get further than 6 records, as when I try to enter an 'Actionee', it seems locked. Even if I open the form in edit mode, I can't change the actionee. What have I done wrong?
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Problem Control (2003)

    Log No is an AutoNumber in both tables. Your relationships indicate a one to many relationship between tblOpportunity Main and tblOpportunity. If this is what you want change Log No in tblOpportunity to Number.
    Thanks
    chuck

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

    Re: Problem Control (2003)

    In the previous database, I had two forms for some reason. One for entering data, and one for editing. This seemed to work (I had a lot of help from Hans and other members). I'd missed the second form off in this case. Now I've added it, everything seems to be working. Thanks for your advice.

Posting Permissions

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