1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Connecting Data from Form Fields to Table Fields

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

  1. tracylynn2u

    tracylynn2u New Member

    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

    [COMMENT]Please change your sig to 4 lines. Also refer to the signature policy[/comment]
     

Share This Page