Connecting Data from Form Fields to Table Fields

tracylynn2u's Avatar, Join Date: Jun 2008
Newbie 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

Thanks
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Offtopic comment:
Please change your sig to 4 lines. Also refer to the signature policy