A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help with Control Source usage please...



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2004, 04:10 PM
external usenet poster
 
Posts: n/a
Default Need help with Control Source usage please...

Scenario... there are two fields on a form created from a
table. Both fields are combo boxes which show a unit
number and unit description (i.e P06|Pipe Fitting).
One field shows and uses the Unit number...the other
field shows the same info in reverse (Pipe Fitting|P06)
and uses the Unit Description when selected. Both fields
will auto fill the other field, so if you know the unit
number and enter that, the next field will auto fill with
the unit description and vice a versa. I did this by
designating one field the Control Source on the Data Tab
on the Properties sheet for both fields.

Here is the problem:

I enter data into the form, then I check the Data sheet
view and everything is fine, all fields are filling in
appropriately. HOWEVER...When I view the associated Table
the fields with the designated control source are empty!
Suppose the Unit Number field is the control source for
the Unit Number and the Unit Description field...on the
assicated table the entry for the Unit Number field is
displayed...but the data for the Unit Description field
is empty.

What I need:

Someone should be able to look up the appropriate Unit
Number, enter the number...then the Unit description
field should Auto fill. Both fields should show an entry
in the associated table.

This is a very important project I have undertaken for my
company. I sincerely appreciate any help you may have to
offer. Please feel free to email a responce to
or to post it here so others may have
the benefit of your wisdom.

Regards, James

  #2  
Old May 20th, 2004, 09:59 PM
tina
external usenet poster
 
Posts: n/a
Default Need help with Control Source usage please...

if you have a table, such as

tblUnits
UnitNum
UnitDesc

and you're using that table to offer data entry selections for a field in
another table, via a form, then your form setup sounds fine.
the "other" table should not have a separate unit description field, only a
unit number field. you've already got the description for any given unit
number - in tblUnits. storing the same data in two separate tables violates
table normalization rules and defeats the purpose of using a relational
database model.

hth


wrote in message
...
Scenario... there are two fields on a form created from a
table. Both fields are combo boxes which show a unit
number and unit description (i.e P06|Pipe Fitting).
One field shows and uses the Unit number...the other
field shows the same info in reverse (Pipe Fitting|P06)
and uses the Unit Description when selected. Both fields
will auto fill the other field, so if you know the unit
number and enter that, the next field will auto fill with
the unit description and vice a versa. I did this by
designating one field the Control Source on the Data Tab
on the Properties sheet for both fields.

Here is the problem:

I enter data into the form, then I check the Data sheet
view and everything is fine, all fields are filling in
appropriately. HOWEVER...When I view the associated Table
the fields with the designated control source are empty!
Suppose the Unit Number field is the control source for
the Unit Number and the Unit Description field...on the
assicated table the entry for the Unit Number field is
displayed...but the data for the Unit Description field
is empty.

What I need:

Someone should be able to look up the appropriate Unit
Number, enter the number...then the Unit description
field should Auto fill. Both fields should show an entry
in the associated table.

This is a very important project I have undertaken for my
company. I sincerely appreciate any help you may have to
offer. Please feel free to email a responce to
or to post it here so others may have
the benefit of your wisdom.

Regards, James



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.