Updating table from subform

  • Thread starter Thread starter Try Hard
  • Start date Start date
T

Try Hard

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.
 
Include a field for the Person in the subform's RecordSource query so that
you are uniquely changing only that person's record.
 
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.
 
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)?
 
Thanks Ken

Ken Snell (MVP) said:
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)?
Click to expand...
 
Back
Top