Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Connecting Data from Form Fields to Table Fields (http://www.go4expert.com/forums/connecting-data-form-fields-table-fields-t11272/)

tracylynn2u 11Jun2008 20:23

Connecting Data from Form Fields to Table Fields
 
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

shabbir 12Jun2008 09:31

Re: Connecting Data from Form Fields to Table Fields
 
Offtopic comment:
Please change your sig to 4 lines. Also refer to the signature policy


All times are GMT +5.5. The time now is 08:47.