Results 1 to 4 of 4
  1. #1
    thekruser is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    93

    Arrow Reflect information from one form in a confirmation form?

    What I have:
    Two forms: one with a series of txt, cbo, and lst boxes. The other should reflect the information in the first.

    What I am trying to do:
    User enters information in form A then clicks 'Continue'. Form B (confirmation form) opens and displays the data entered in form A for the user to review and certify. Once the user has verified the info, they click 'Continue' and go on about their way.

    The problem:
    I do not know how to get the information from form A into form B and still have it look professional. I know how to display the data in form B using an unbound cbo or lst by setting the default value to:

    Code:
    [Forms]![frmFormA].[cboComboBoxOnFormA]
    The problem with this method is, the dropdown arrow is still diplayed. Form B should simply look like:

    Name: John Smith


    Address: 123 My Street
    Etc, etc.

    The appearance of a dropdown arrow leads the user to believe they can edit the data on form B, when in fact, all of the data on form B is locked.

    I am not sure how to get the data to display in a txt box. When I add the above code to the default value it errors.

    Any help would be greatly appreciated! Thank you in advance for your time.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I would think the RecordSource would be the same for both forms so there would be no reason to look at the previous form, just pass the 2nd form the PrimaryKey.

  3. #3
    thekruser is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    93
    Prime example of me posting before I stopped, reset, and looked at it from another angle. Thanks, RuralGuy. That is what I should have done in the beginning.

    However, now that I have posted this, for future reference, you have any idea how to get it to work? I am thinking this would be applicable if the primary form fills data into multiple tables. For example:

    tblEmployee
    -EmplNo (PK)
    -LName
    -FName
    -CityID (FK)
    -StateID (FK)

    tblCity
    -CityID (PK)
    -City

    tblState
    -StateID
    -State

    In the case something like this was in need of a certifiacation step, how would the info be displayed on form B? It would still result in the same issue. Passing EmplNo pk to the form would result in something like '15' for city and '25' for state. If the city does not exist in tblCity, what would you do then?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The 2nd form would have a Query for a RecordSource that joins the three tables just like the first form. If a City needs to be added to the tblCity table then you do it in the NotInList event of the ComboBox on the 1st form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Export Form but Keep Information?
    By SpeedyApocalypse in forum Forms
    Replies: 4
    Last Post: 04-09-2010, 07:30 AM
  2. Open Form with information from previous form
    By jheintz57 in forum Forms
    Replies: 9
    Last Post: 03-23-2010, 07:30 AM
  3. Pull information to a form, from another form
    By lpddt in forum Programming
    Replies: 1
    Last Post: 10-28-2009, 03:37 PM
  4. Moving Information from One Form to Another
    By bsharpbyoung in forum Forms
    Replies: 2
    Last Post: 03-22-2009, 09:37 PM
  5. Form that hides information
    By dromorkid in forum Forms
    Replies: 0
    Last Post: 11-04-2008, 11:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums