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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Microsoft Access 2007 Update fields
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 |
#2
|
|||
|
|||
Microsoft Access 2007 Update fields
Are you talking about Lookup Fields?
http://www.mvps.org/access/lookupfields.htm Thel wrote: 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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200902/1 |
#3
|
|||
|
|||
Microsoft Access 2007 Update fields
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" wrote in message ... 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 |
#4
|
|||
|
|||
Microsoft Access 2007 Update fields
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. "ruralguy via AccessMonster.com" wrote: Are you talking about Lookup Fields? http://www.mvps.org/access/lookupfields.htm Thel wrote: 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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200902/1 |
#5
|
|||
|
|||
Microsoft Access 2007 Update fields
Yes
"ruralguy via AccessMonster.com" wrote: Are you talking about Lookup Fields? http://www.mvps.org/access/lookupfields.htm Thel wrote: 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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200902/1 |
#6
|
|||
|
|||
Microsoft Access 2007 Update fields
As the link I posted strongly recommends: Do not use Lookup Fields. Use bound
ComboBoxes on forms to do the lookup instead. Thel wrote: 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] Any help would be greatly appericated. Thelma -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com |
#7
|
|||
|
|||
Microsoft Access 2007 Update fields
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 "Gina Whipp" wrote: 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" wrote in message ... 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 |
#8
|
|||
|
|||
Microsoft Access 2007 Update fields
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" wrote: 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" wrote in message ... 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 |
#9
|
|||
|
|||
Microsoft Access 2007 Update 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. -- 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" wrote in message ... 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" wrote: 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" wrote in message ... 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 |
#10
|
|||
|
|||
Microsoft Access 2007 Update fields
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? "Gina Whipp" wrote: 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" wrote in message ... 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" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|