Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Subforms? (Access 97)

    Every table and form in my database uses a field that joins back to an Employee table. This is where I get the "Analyst Name" from. Each record is based on a single analyst entering the information. I will be creating a new form that a manager will update. The manager will have a list of all analyst and the call records for each person. Instead of creating a form that will require the manager to enter a new record for each person for the month, is there a way to create a form that will provide a table, by month, by person, that the manager can update? I want this to create individual records for each analyst for reporting. Could I use a subform?

    thanks
    christine
    thanks
    christine

  2. #2
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms? (Access 97)

    What is the manager updating. Could you post your table structure, and a little more detail on what the managers are going to 'edit'.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Subforms? (Access 97)

    The manager was going to update each user's calls individually each month. One record, per user, per month. What their looking for is a form that will list all users in a table and allow the manager to update only the call info. The user info would be fixed. But I want to be able to report on each user separately.
    Attached Files Attached Files
    thanks
    christine

  4. #4
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms? (Access 97)

    Okay a few things. Off of the original question, I recommend using AutoNumber ID's for actual record keys. Using human generated 'keys' can cause problems in the future.

    As for your question, I would go about this one of two ways. One way would be to create a bound form that has a recordset behind it filtered by manager. Have that form be locked to just show the User info you want to show for each user (No editing...just showing who is who), then have a subform linked by the UserID, for the call info for that user.

    An unbound method would be to have the list of users show up in a listbox. Then have unbound fields that fill or save based upon the selection in the listbox.

Posting Permissions

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