1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Connecting Data from Form Fields to Table Fields

Discussion in 'MS Access' started by tracylynn2u, Jun 11, 2008.

  1. tracylynn2u

    tracylynn2u New Member

    Joined:
    Jun 9, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I am creating a somewhat extensive database with several categories of data and many relational tables. I built tables and created forms from these tables. However, as I started to input data I decided to make some combo boxes on some of my forms that have hidden data which fills in another field inside the form.

    When I view the table that is connected with the form the data from the combo box field does not fill in the data that's not hidden. The hidden data is there but not the visible info. I can see the rep number in the table and not the rep's last name. I've been having to open the table and type the name in the field beside the rep number.

    Example:

    Form w/Combo Box 1 = visible / Marketing rep last name - Row Source Type = Table/Query

    Row Source formulation is SELECT [WNY Marketing Reps].[ID #], [WNY Marketing Reps].[Last Name] FROM [WNY Marketing Reps] ORDER BY [Last Name], [ID #];

    Field w/hidden data = Marketing rep ID# - Row Source Type = Table/Query

    Row Source formulation is WNY Marketing Reps

    Table w/connected data = Marketing Rep Last Name Row Source Type = Table/Query

    Row Source Formulation is SELECT [WNY Marketing Reps].[Last Name], [WNY Marketing Reps].[ID #], [WNY Marketing Reps].[ID #] FROM [WNY Marketing Reps] ORDER BY [WNY Marketing Reps].[Last Name], [WNY Marketing Reps].[ID #];

    Marketing Rep ID# - Row Source Type = Table/Query

    Row Source formulation is WNY Marketing Reps

    I would like my table to complete the Reps last name so I don't have to go in and do it manually. Any help would be appreciated. I hope this is posted clearly :crazy:

    Thanks
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    [COMMENT]Please change your sig to 4 lines. Also refer to the signature policy[/comment]
     

Share This Page