Microsoft Access 2007 Update fields

[Thel]

I am using a form to update a table. I have 3 update fields in a table.
When I do the lookup all three fields show on the form but only one updates.
How do I get the other two fields to update?
Any help would be greatly appericated.
Thelma

 

[ruralguy via AccessMonster.com]

Are you talking about Lookup Fields?
http://www.mvps.org/access/lookupfields.htm

 

[Gina Whipp]

Thel,

I am trying to understand this...

You have three fields you wish to update to a table but presently only one
is updating. IF that is what you are saying then we need to know how you
you are updating the three fields. Are you just typing the information in
but it's not appearing in the table? Are you using a query to update the
table and the query is not performing it's job. Or maybe the fields as
combo boxes and the field is not accepting the selections from the combo
box? Of,course you should get some sort of message unless you turned those
off??? Or maybe it's the RecordSOurce of the form, when you go to design
mode of the form does the word 'unbound' show in two of the three fields?

It would also help to know what version of Access?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Thel]

Yes it is a lookup field, I have a form called employee that looks up the
dept, desc and glcode in the table called dept# it will update the dept# not
the other two fields.

 

[Thel]

Yes

Are you talking about Lookup Fields?
http://www.mvps.org/access/lookupfields.htm

 

[ruralguy via AccessMonster.com]

As the link I posted strongly recommends: Do not use Lookup Fields. Use bound
ComboBoxes on forms to do the lookup instead.

Yes it is a lookup field, I have a form called employee that looks up the
dept, desc and glcode in the table called dept# it will update the dept# not
the other two fields.

Are you talking about Lookup Fields?
http://www.mvps.org/access/lookupfields.htm

[quoted text clipped - 4 lines]

 

[Thel]

I am using access 2007,
I am using a form and a lookup table with joins to the dept table. sorry if
I don't explain this too well I have been a programmer for many years (Cobol)
and access is very new to me.
Thanks

 

[Thel]

on the form I type in the dept number and it fills in the desc & glcode, when
you look at the table it has updated the dept number but not the other two
fields.
I am using access 2007.
I am not getting any messages.

 

[Gina Whipp]

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Thel]

How do I tell access it is a combo box on the form? All of the information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

 

[ruralguy via AccessMonster.com]

Does the Dept# table have the "other two" fields data for the form?

How do I tell access it is a combo box on the form? All of the information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.

[quoted text clipped - 31 lines]

 

[Gina Whipp]

Thel,

I think you need to specify your table layouts. There might be an issue
there as to why these fields are not updating properly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Thel]

The Dept table has all three fields. When entering data on the form the user
wants to type in the dept# and have the other to fields field in automaticly.
Thanks,

Does the Dept# table have the "other two" fields data for the form?

How do I tell access it is a combo box on the form? All of the information
is coming from the employee table except these three fields. If I use a
combo box can the user put in the dept# and update the other two fields?

I would suggest reading up on why using look-up fields in tables causes
problem. Eliminate them and use a table/combo box on a form.

[quoted text clipped - 31 lines]

Any help would be greatly appericated.
Thelma

 

[Thel]

My Table layout for Employee is dept desc employee name (key field) address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

 

[ruralguy via AccessMonster.com]

You need to create a query that joins the two tables on the Dept# field and
includes all of the fields you need from either table.

The Dept table has all three fields. When entering data on the form the user
wants to type in the dept# and have the other to fields field in automaticly.
Thanks,

Does the Dept# table have the "other two" fields data for the form?

[quoted text clipped - 7 lines]

 

[Gina Whipp]

Thel,

First, yhou do not need to store GLCODE and Dept Desc in both tables unless
you are alowwing changes to those fields independent from the Department
Table. What you do need in the Emplyee table id Dept#. Then create a query
that joins the two tables together via Dept# and that will help those field
show but you REALLY don't need to or want to store duplicate information.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[ruralguy via AccessMonster.com]

It is wise to name like fields the same in different tables. It is not wise
to use the "#" sign in a field name. Are the two Dept fields the same
DataType?

My Table layout for Employee is dept desc employee name (key field) address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

Thel,

[quoted text clipped - 51 lines]

 

[Thel]

The name are the same in both tables. The dept table is for inputing
information,
the user does not want to lookup the data she needs to put in.
if she knows the dept nbr she wants it to put desc and glcode that match
that dept.
The coorsponding field are all of the same data type.

It is wise to name like fields the same in different tables. It is not wise
to use the "#" sign in a field name. Are the two Dept fields the same
DataType?

My Table layout for Employee is dept desc employee name (key field) address,
city, state zip, status, phone number, wage, ssn, GLcode.
The layout of the Dept# is dept# Desc, GLCODE
Thanks

Thel,

[quoted text clipped - 51 lines]

Any help would be greatly appericated.
Thelma

 

[Thel]

dept, desc and glcode are in both tables with the same name and data type.
The user want to be able to put in the dept and access fill in the desc and
glcode on the input form.

 

[Gina Whipp]

Thel,

Those can APPEAR but not be STORED in the table. Storing the same data in
two places defeats the purpose of normalization. The User will SEE the data
and that's all the User really wants to do. They will not have to type
anything into any extra fields.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm