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
|
|||
|
|||
Updating table from subform
I have a subform were I enter dates that people have been trained in working
instructions, these instructions are linked to positions held. The problem arises when I link more than one person to a position and hence a work instruction. When I enter a date in the subform for a particular work instruction and position it changes the date for any other person that has been trained in that same positions work instruction. |
#2
|
|||
|
|||
Updating table from subform
Include a field for the Person in the subform's RecordSource query so that
you are uniquely changing only that person's record. -- Ken Snell MS ACCESS MVP "Try Hard" wrote in message ... I have a subform were I enter dates that people have been trained in working instructions, these instructions are linked to positions held. The problem arises when I link more than one person to a position and hence a work instruction. When I enter a date in the subform for a particular work instruction and position it changes the date for any other person that has been trained in that same positions work instruction. |
#3
|
|||
|
|||
Updating table from subform
Ken, thanks mate. I have a couple of another questions? I have changed the
RecordSource as you indicated and yes this worked, but, the record I inputed is not displayed in the subform (I dont know were Im up to) and can I have all the records in the subform rather than selecting them by a combo box? Again your help would be apprecited. "Ken Snell (MVP)" wrote: Include a field for the Person in the subform's RecordSource query so that you are uniquely changing only that person's record. -- Ken Snell MS ACCESS MVP "Try Hard" wrote in message ... I have a subform were I enter dates that people have been trained in working instructions, these instructions are linked to positions held. The problem arises when I link more than one person to a position and hence a work instruction. When I enter a date in the subform for a particular work instruction and position it changes the date for any other person that has been trained in that same positions work instruction. |
#4
|
|||
|
|||
Updating table from subform
Did you also add the Person field to the LinkChildFields and the Person
combobox to the LinkMasterFields properties of the subform control (the control that actually holds the subform object)? -- Ken Snell MS ACCESS MVP "Try Hard" wrote in message ... Ken, thanks mate. I have a couple of another questions? I have changed the RecordSource as you indicated and yes this worked, but, the record I inputed is not displayed in the subform (I dont know were Im up to) and can I have all the records in the subform rather than selecting them by a combo box? Again your help would be apprecited. "Ken Snell (MVP)" wrote: Include a field for the Person in the subform's RecordSource query so that you are uniquely changing only that person's record. -- Ken Snell MS ACCESS MVP "Try Hard" wrote in message ... I have a subform were I enter dates that people have been trained in working instructions, these instructions are linked to positions held. The problem arises when I link more than one person to a position and hence a work instruction. When I enter a date in the subform for a particular work instruction and position it changes the date for any other person that has been trained in that same positions work instruction. |
#5
|
|||
|
|||
Updating table from subform
Thanks Ken
"Ken Snell (MVP)" wrote: Did you also add the Person field to the LinkChildFields and the Person combobox to the LinkMasterFields properties of the subform control (the control that actually holds the subform object)? -- Ken Snell MS ACCESS MVP "Try Hard" wrote in message ... Ken, thanks mate. I have a couple of another questions? I have changed the RecordSource as you indicated and yes this worked, but, the record I inputed is not displayed in the subform (I dont know were Im up to) and can I have all the records in the subform rather than selecting them by a combo box? Again your help would be apprecited. "Ken Snell (MVP)" wrote: Include a field for the Person in the subform's RecordSource query so that you are uniquely changing only that person's record. -- Ken Snell MS ACCESS MVP "Try Hard" wrote in message ... I have a subform were I enter dates that people have been trained in working instructions, these instructions are linked to positions held. The problem arises when I link more than one person to a position and hence a work instruction. When I enter a date in the subform for a particular work instruction and position it changes the date for any other person that has been trained in that same positions work instruction. |
Thread Tools | |
Display Modes | |
|
|