• Subforms? (Access 97)

    Author
    Topic
    #382429

    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

    Viewing 0 reply threads
    Author
    Replies
    • #648347

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

      • #648368

        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.

        • #648372

          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.

    Viewing 0 reply threads
    Reply To: Subforms? (Access 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: