Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: Form will not close properly after report

    I have a custom switchboard that opens a data entry form based on several prompts (additional forms for user name date and password). Everything works correctly. When you close out of the data entry form, you return to the switchboard. If you click the button to open the data entry form again you are prompted for all new information and see the new user info. However, if while viewing the entry form as user "a" you call a report. When you close out the report and form and enter user data for user "b" you will see user "a" data as well as see user "a" information on the report. Even though you enter user "b" name and password. Help!

  2. #2
    Join Date
    Aug 2007
    Posts
    25
    Are you closing the report and form from the same procedure?
    Kirk Wahl
    GM Powertrain SMCO

  3. #3
    Join Date
    Jan 2004
    Posts
    6

    Re

    No the report closes and the form which was hidden is reopened. Then the form is closed. All by the user.

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    did you or someone else design the database - the reason I am asking is if it is possible one of the forms (the user form ) is being set to not visible or looking at a recordset and not the controls on the form that is used to filter or set the criteria of the data.
    Dale Houston, TX

  5. #5
    Join Date
    Aug 2007
    Posts
    25
    It sounds as though to need to change the sub routine or function to re-query both the form, and the report.
    Kirk Wahl
    GM Powertrain SMCO

Posting Permissions

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